SQL Server: Search for a Column Name in a Database

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