SQL find all tables where column name =

This is a fast and simple way to find all tables in a SQL database which contains a specific column.

[sql]
SELECT COLUMN_NAME, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE ‘%MyColumn%’
[/sql]