Re: Query help
Navdeep Virk wrote:
>
> Hi ,
>
> 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"
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. |/ ////////|
+----------------------+-----------------------------------+-----------+