How can I find specified column name in all table ? - Get all column name in table

SELECT      columns.name AS ColumnName,tables.name AS TableName
FROM        sys.columns columns
JOIN        sys.tables  tables   ON columns.object_id = tables.object_id
WHERE       columns.name LIKE '%COLUMN-NAME%'