Re: SQL to search for column name

select a.tabname, b.colname from systables a, syscolumns b where a.tabid = b.tabid and b.colname = 'vendor' --- Chad Douglas <c320f@yahoo.com> wrote: > I'm using informix SE 7.23.UC13 and I'm looking for an SQL statement > that will do a wildcard search for a column name from all tables. I > would like to get a list of any column that contains "vendor" from > all > tables. I don't want it to display any data contained in the column > just the column name and table. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > <div id="RTEContent">DL Redden <br> <br>Visit my wifes web site <a href="http://www.lishalynn.com">www.lishalynn.com</a>; for all of your makeup and skin care needs.</div>