Find column name in all table

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%column name%' ORDER BY TABLE_NAME