Re: Query help
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!
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. |/ ////////|
+----------------------+-----------------------------------+-----------+