use EmployeeGOSELECT OBJECT_NAME(c.object_id) TableName, c.name ,SCHEMA_NAME( schema_id)FROM sys.columns cJOIN Sys.objects o on c.object_id = o.object_idWHERE c.name = 'Emp_ID'and o.type = 'U'
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
Login to post response