例: 1.对表的说明 SQL> comment on table scott.emp is '员工信息'; 2.对表中列的说明 SQL> comment on column scott.emp.empno is '员工编号'; 3.查看表的说明 SQL> select * from user_tab_comments where TABLE_NAME='EMP'; SQL> select * from user_tab_comments where comments is not null; 4.查看表中列的说明 SQL> select * from user_col_comments where TABLE_NAME='EMP'; SQL> select * from user_tab_comments where comments is not null; 5.我们也可以从下面这些视图中查看表级和列级说明: ALL_COL_COMMENTS USER_COL_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS 6.删除表级说明,也就是将其置为空 SQL> comment on table emp is '' 7.删除列级说明,也是将其置为空 SQL> comment on column emp.empno is '';