MS SQL query for searching in column names.

  • Published by steve on 5 January 2012.

Search column names for keywords using "like"

SELECT name FROM sysobjects
WHERE id IN (
SELECT id FROM syscolumns WHERE name like '%KEYWORD%' )