Re: Query help

Posted in 2000

Obnoxio The Clown — Thu, 20 Jul 2000 23:14:34 BST — source: Informix-list mailing list archive (1991-1998)

From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >Obnoxio The Clown wrote: > > > > From: "Navdeep Virk" <NVirk@vsi-hq.com> > > > > > >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. > > > > SELECT tabname > > FROM systables t, syscolumns c > > WHERE c.tabid = t.tabid > > AND colname = "foobar"> >Ooh! That's scary! That's funny... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com