alter table table_name add column_name column_properties;
comment on column table_name.column_name is 'comment';

 

1、给表填加注释:comment on table 表名 is '表注释";

2、给列加注释:   comment on column 表.列 is '列注释';

3、读取表注释:   select * from user_tab_comments where comments is not null;

4、读取列注释:   select * from user_col_commnents where comments is not null and table_name='表名';

Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐