Re: Query help

Posted in 2000

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

From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >Navdeep Virk wrote: > > > > 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. > >Yes, something like: > > SELECT tabname > FROM systables t, syscolumns c > WHERE t.tabid = c.tabid > AND c.colname = "foobar" Didn't I just say that? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com