Locate all columns in a database matching a specified name
Submitted by jeff on Wed, 09/22/2010 - 15:06
For SQL 2005+. This finds any columns that have Status somewhere in the column name.
Select SCH.Name as SchemaName, OBJ.Name as ObjectName, COL.Name as ColumnName from Sys.Objects OBJ Inner join Sys.Schemas SCH on OBJ.Schema_ID = SCH.Schema_ID Inner join Sys.Columns COL on OBJ.Object_ID = COL.Object_ID Where COL.Name like '%Status%' Order by SchemaName, ObjectName, ColumnName