개발/DataBase
[MSSQL]컬럼명으로 테이블 찾기
Deceitter
2022. 3. 23. 14:57
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 = '[컬럼명]'
반응형