RE: SQL to search for column name

Posted in 2006

Hamilton, Jerry — Thu, 19 Jan 2006 09:53:58 -0600 — source: Usenet: comp.databases.informix

select tabname[1,18], colname from systables t, syscolumns c where t.tabid = c.tabid and colname matches "-type your column name here!-" order by 1,2 -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Chad Douglas Sent: Thursday, January 19, 2006 9:29 AM To: informix-list@iiug.org Subject: SQL to search for column name 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