DataBase/Oracle
특정 테이블 스키마 보기
탑~!
2012. 5. 16. 15:15
SELECT B.COLUMN_NAME AS 컬럼명
, B.DATA_TYPE AS 테이터타입,
B.DATA_LENGTH AS 길이,
B.NULLABLE AS NULL구분,
B.COLUMN_ID AS 컬럼순서,
A.COMMENTS AS 설명
FROM USER_COL_COMMENTS A, USER_TAB_COLUMNS B
WHERE B.TABLE_NAME = A.TABLE_NAME
AND B.COLUMN_NAME = A.COLUMN_NAME
AND B.TABLE_NAME LIKE 'TC_PROG'
ORDER BY B.COLUMN_ID;
728x90
반응형