RE: Query help

Posted in 2000

Demus, Alan — Thu, 20 Jul 2000 15:28:05 -0500 — source: Informix-list mailing list archive (1991-1998)

How odd are these tables? Try a query on syscolumns, join by tabid to systables. > -----Original Message----- > From: Navdeep Virk [SMTP:NVirk@vsi-hq.com] > Sent: Thursday, July 20, 2000 3: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