mysql: get all tables in database that have a column called xyz

Question

Town · Accepted Answer · 2011-03-31 13:14:51Z

7

Both SQL Server and MySql have the Information_Schema.Columns table: http://dev.mysql.com/doc/refman/5.1/en/columns-table.html

select c.table_name from 
information_schema.columns c 
where c.column_name = 'xyz'

answered Mar 17, 2009 at 15:02

Town

14.9k3 gold badges50 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yes, MySQL has that too and the Statement works fine, but why are you using "like" without any wildcard instead of "=" ?

Copy/pasted it from a quick test on our DB here where i was using a wildcard, fixed now - ta! :)