Home

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
»