Posts

Showing posts from April, 2012

Search through the schema information to find all tables having specific column as member columns.

Search through the schema information to find all tables having specific column  as member columns.

Have you ever thought to scan through all the database tables to find list of tables containing column with specific column name.
Here is the solution -
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name LIKE '%ABCD%'

Hope this saves couple of minutes opening all the table designers and look for the column in the list of column.

Regards,
Kritul