1. 表的注释
comment on table t_A is '表的注释';
2. 列的注释
comment on column t_A.id is '编号';
comment on column t_A.name is '姓名';
comment on column t_A.birthday is '出生日期';
comment on column t_A.sal is '薪水';
3. 查看表的注释(注意值全部是大写)
select * from user_tab_comments where table_name = 'T_A';
4. 查看列的注释(注意值全部是大写)
select * from user_col_comments where table_name = 'T_A';