查看表的注释
select * from user_tab_comments;
查看表中字段的注释
select * from user_col_comments;
给表添加注释
comment on table tablename is ‘注释’;
给字段添加注释
comment on column tablename.colname is ‘注释’;
详情请见:oracle注释
select * from user_tab_comments;
select * from user_col_comments;
comment on table tablename is ‘注释’;
comment on column tablename.colname is ‘注释’;
详情请见:oracle注释