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
반응형