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…
Leave a Comment