Re: Query help
database yourdatabase;
select a.tabname,b.colname
from systables a, syscolumns b
where a.tabid = b.tabid
and b.colname = 'foobar'
-Prasad Mahale
pmahale@yahoo.com
>From: "Navdeep Virk" <NVirk@vsi-hq.com>
>To: "informix-list@iiug.org" <informix-list@iiug.org>
>Subject: Query help
>Date: Thu, 20 Jul 2000 16:19:02 -0400
>
>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.
>
>TIA
>NSV
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com