Finding table Name using Column Name

Kirthiga
Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 861
Select a.name as [Table Name], c.name as [Column Name]
From sys.tables as a
Inner Join sys.columns c on a.OBJECT_ID = c.OBJECT_ID
Where c.name Like '%police%'--Column Name
Order By [Table Name]

Comments or Responses

Posted by: Learningtorise on: 5/8/2013 Level:Starter | Status: [Member] | Points: 10
nice..
Posted by: Learningtorise on: 5/8/2013 Level:Starter | Status: [Member] | Points: 10
nice..

Login to post response