– Since SQL Server 2005 Management Studio lacks the Object Search feature, here is the simple query to find any column in a database

1
2Select O.name objectName, C.name ColumnName
3from sys.columns C inner join sys.objects O
4ON C.object_id=O.object_id
5where C.name like ‘%ColumntoFind%’order by O.name,C.name

– This query works for SQL Server 20005. Just replace “ColumnToFind” with your required column name.

 1SELECT
 2OBJECT_NAME(c.OBJECT_ID) TableName
 3,c.name AS ColumnName
 4,SCHEMA_NAME(t.schema_id) AS SchemaName
 5,t.name AS TypeName
 6,t.is_user_defined
 7,t.is_assembly_type
 8,c.max_length
 9,c.PRECISION
10,c.scale
11FROM sys.columns AS c
12JOIN sys.types AS t ON c.user_type_id=t.user_type_id
13where
14C.name like '%ColumntoFind%'
15ORDER BY c.OBJECT_ID;

– Site d’origine : Pinal Dave ( http://blog.SQLAuthority.com/ ) – Site d’origine : http://blog.namwarrizvi.com/