RE: syscolnames

Posted in 2000

Murray Wood — Thu, 16 Nov 2000 09:30:56 +1300 — source: Informix-list mailing list archive (1991-1998)

tabid in systables which contains the table name (tabname) -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of mrhodes Sent: Thursday, November 16, 2000 6:25 AM To: informix-list@iiug.org Subject: syscolnames Does anyone know what the tabid in the syscolnames ties to? colname disc_flg tabid 386 colno 9 coltype 0 collength 1 colmin colmax I thought it would tie to sysmaster:systabnames but it only has a partnum that does not match. I am trying to write an sql that would allow me to search for the table that a particular column is in. MDR