Books for asp.net

Monday, May 18, 2009

MSSQL 2005 : Search Column name

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