[MS-SQL]특정 칼럼명을 가진 테이블을 검색

반응형

---------------------------------------------------
--특정 칼럼명을 가진 테이블을 검색
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='RotCnt'​
---------------------------------------------------

출처: https://devdb.tistory.com/29 [DB 관련:티스토리]