DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Search For All Column Names That Contain A Certain String Within MS SQL Server 2005
Search for all column names that contain a certain string within MS SQL Server 2005
Select O.name objectName, C.name ColumnName from sys.columns C inner join sys.objects O ON C.object_id=O.object_id where C.name like ‘%ColumntoFind%’ order by O.name,C.name
