Re: Query help

Posted in 2000

Obnoxio The Clown — Thu, 20 Jul 2000 21:37:24 BST — source: Informix-list mailing list archive (1991-1998)

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" ? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com