Oracle

Adding Comments to a Table

Figo Kim 2006. 11. 27. 22:59
COMMENT ON TABLE employees IS 'Employee Information';

-  Related Views :
  ALL_COL_COMMENTS, USER_COLS_COMMENTS, ALL_TAB_COMMENTS, USER_TAB_COMMENTS

- Up to 400 bytes

ex) select * from user_tab_comments where table_name = 'EMPLOYEES'

TABLE_NAME TABLE_TYPE COMMENTS
EMPLOYEES TABLE Employee Information