comment on的意义

给表添加注释的方式
comment on table table_name is ‘对表注释的内容’;
查询某表的注释
select * from user_tab_comments where table_name = ‘TABLE_NAME’;
给列添加注释内容的方式，有多少个列应该写多少个
comment on column table_name.column1 is ‘对column 1列注释的内容’;
查询某表下某列的注释
select * from user_col_comments where table_name = ‘TABLE_NAME’ and column_name = ‘column1’;