Searching a Database for Columns

This is just a quick little post on a useful query that I find myself using quite often. It allows me to search a database for a column using a LIKE statement. For example here I am searching the database for all columns (from both tables and views) that contain the word catalog.

select * From INFORMATION_SCHEMA.COLUMNS 
Where COLUMN_NAME like '%catalog%'

Just thought I would Share…