syscolnames

Posted in 2000

mrhodes — Wed, 15 Nov 2000 10:25:27 -0700 — source: Informix-list mailing list archive (1991-1998)

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 mrhodes

Joachim Claeys — Thu, 16 Nov 2000 12:28:24 GMT — source: Informix-list mailing list archive (1991-1998)

To the systables.tabid ?! Joachim. mrhodes wrote: > 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