Re: SQL to search for column name

Posted in 2006

DL Redden — Thu, 19 Jan 2006 09:38:13 -0800 (PST) — source: Usenet: comp.databases.informix

Good eye. Missed the "contains". --- bozon <curtis@crowson1.com> wrote: > >Even though I so ashamedly answered the question properly. > Well you almost got it right. > > >>get a list of any column that contains "vendor" > > which would look like > > select a.tabname, b.colname > from systables a, syscolumns b > where a.tabid = b.tabid and b.colname like '%vendor%'> > _______________________________________________ > 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>