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 NameOrder By [Table Name]
Login to post response