HappyWeasel
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 Like '%컬럼명%'
Comments
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 Like '%컬럼명%'