MSSQL 컬럼을 보유한 테이블 조회, 전체 컬럼 확인하기

 -- MSSQL 전체컬럼 확인방법
SELECT
   TBLNAME.name AS TBLNAME, COLNAME.name AS COLNAME
FROM
   sys.tables AS TBLNAME
   INNER JOIN sys.columns AS COLNAME ON TBLNAME.object_id = COLNAME.object_id


-- MSSQL 특정컬럼 검색방법
SELECT
   TBLNAME.name AS table_name, COLNAME.name AS column_name
FROM
   sys.tables AS TBLNAME
   INNER JOIN sys.columns AS COLNAME ON TBLNAME.object_id = COLNAME.object_id
WHERE
COLNAME.name = '찾으려는 컬럼명'