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.

SELECT COLUMN_NAME, TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%MyColumn%'