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 'address1'
order by O.name,C.name
Monday, May 18, 2009
MSSQL 2005 : Search Column name
Posted by
Khairul
at
Monday, May 18, 2009
Labels: MSSQL
Subscribe to:
Comments (Atom)
