Cacher is the code snippet organizer for pro developers

SELECT COLUMN_NAME AS [ColumnName]
       ,TABLE_NAME AS  [TableName]
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%columnsearch%'
ORDER BY TableName ,ColumnName;