RE: Query help
Try this in SQL . . . .
database <db_name>;
select tabname, colname
from syscolumns col, systables tab
where colname = 'foobar'
and col.tabid = tab.tabid
> -----Original Message-----
> From: Navdeep Virk [mailto:NVirk@vsi-hq.com]
> Sent: Thursday, July 20, 2000 4:19 PM
> To: informix-list@iiug.org
> Subject: Query help
>
>
> Hi ,
>
> I would like to find the tables which contain the column name foobar
> from say 270 odd tables. can this be done by query the systabs.
>
> TIA
> NSV
>