[DB] 해당 테이블의 컬럼가져오기

오라클

select DISTINCT TABLE_NAME, COLUMN_NAME

 

from ALL_TAB_COLUMNS

 

where TABLE_NAME = '해당테이블' AND OWNER = '해당데이터베이스'

ORDER BY COLUMN_NAME DESC;

 

MSSQL

select TABLE_NAME, COLUMN_NAME from information_schema.columns

where table_name = '해당테이블' 

ORDER BY COLUMN_NAME DESC