Search SQL Database for Instances of Column Name

I needed to find where a certain column name was being used. Try this…

SELECT COLUMN_NAME, DATA_TYPE, TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS

--WHERE TABLE_CATALOG = 'YOUR_DATABASE'
--AND COLUMN_NAME LIKE '%YOUR_COLUMN%'
-- Use the above two commented lines as an example of possible queries.
WHERE COLUMN_NAME LIKE 'IsSystem'

Related Posts