Re: Query help

Posted in 2000

Mark D. Stock — Thu, 20 Jul 2000 23:14:43 +0100 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > > 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? Yes. Didn't you know it's rude to copy? Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+