SQL Server Tablo ya da Kolon ismiyle arama

SELECT Table_Name, Column_Name
FROM  INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'YOUR_DATABASE'
AND   COLUMN_NAME LIKE '%YOUR_COLUMN%'