[ORACLE] TABLE, COLUMN COMMENT 입력, 조회

TABLE COMMENT 입력문

 

COMMENT ON TABLE 테이블명 IS '설명'

 

TABLE COMMENT 조회문

 

SELECT A.TABLE_NAME, B.COMMENTS
FROM ALL_TABLES A, ALL_TAB_COMMENTS B
WHERE A.TABLE_NAME = B.TABLE_NAME
ORDER BY A.TABLE_NAME;

 

COLUMN COMMENT 입력문

 

COMMENT ON COLUMN 테이블명.칼럼명  IS '설명'

 

COLUMN COMMENT 조회문

 

SELECT COLUMN_NAME, COMMENTS FROM ALL_COL_COMMENTS WHERE TABLE_NAME = '테이블명'