指定したカラム名を持つテーブルを検索する

SELECT T.name AS TableName,
C.name AS ColumnName
FROM sys.tables AS T
INNER JOIN sys.columns AS C
ON T.object_id = C.object_id
WHERE C.name like ‘%カラム名%’
ORDER BY T.name,
C.name;