참 쉬지요?^^-- ----------------------------- -- 특정컬럼 포함 테이블 조회 -- ----------------------------- SELECT SCHEMA_NAME(schema_id)+'.'+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 = '컬럼명' ORDER BY 1