RE: syscolnames

Posted in 2000

Rick Rabe — Wed, 15 Nov 2000 13:14:08 -0600 — source: Informix-list mailing list archive (1991-1998)

Its tabid in systables. -----Original Message----- From: mrhodes [mailto:mrhodes@rez.com] Sent: Wednesday, November 15, 2000 11: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

↪ replying to Rick Rabe

ckobashi@my-deja.com — Wed, 15 Nov 2000 22:10:42 GMT — source: Informix-list mailing list archive (1991-1998)

You have the answer!. See column tabid in your_db:systables. In article <8uup3t$ftg$1@news.xmission.com>, Rick Rabe <Rick_Rabe@hilton.com> wrote: > > Its tabid in systables. > > -----Original Message----- > From: mrhodes [mailto:mrhodes@rez.com] > Sent: Wednesday, November 15, 2000 11: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 > > Sent via Deja.com http://www.deja.com/ Before you buy.