[MSSQL] 특정 컬럼이 포함된 테이블 찾는 쿼리

SELECT T.name AS table_name, C.name AS column_name

FROM sys.tables AS T

INNER JOIN sys.columns AS C

ON T.object_id = C.object_id

WHERE C.name = '찾을컬럼명' ;

​

​

<참고> 전체 컬럼 확인 쿼리

SELECT T.name AS table_name, C.name AS column_name

FROM sys.tables AS T

INNER JOIN sys.columns AS C

ON T.object_id = C.object_id ;