文档课题：oracle中给表和字段添加注释.

数据库：oracle 11.2.0.4

1、添加注释

1.1、表注释

--添加表注释.

SYS@orcl> create table student_info

  2  (

  3   stu_id int,                  --学号

  4   stu_name varchar2(8),        --姓名

  5   email varchar2(20),          --邮箱

  6   sex char(2),                 --性别

  7   age int,                    --年龄

  8   class_id varchar2(20),        --编辑编号

  9   regdate date default sysdate   --创建时间

 10  );

 

Table created.

 

SYS@orcl> comment on table student_info is '学生信息表';

 

Comment created.

1.2、列注释

--添加列注释.

SYS@orcl> comment on column student_info.stu_id is '学号';

 

Comment created.

 

SYS@orcl> comment on column student_info.stu_name is '姓名';

 

Comment created.

 

SYS@orcl> comment on column student_info.email is '邮箱';

 

Comment created.

 

SYS@orcl> comment on column student_info.sex is '性别';

 

Comment created.

 

SYS@orcl> comment on column student_info.age is '年龄';

 

Comment created.

 

SYS@orcl> comment on column student_info.class_id is '班级编号';

 

Comment created.

 

SYS@orcl> comment on column student_info.regdate is '创建时间';

 

Comment created.

2、查询注释信息

SYS@orcl> select * from all_col_comments where table_name='STUDENT_INFO';

 

OWNER           TABLE_NAME      COLUMN_NAME     COMMENTS

--------------- --------------- --------------- ---------------

SYS             STUDENT_INFO    STU_ID          学号

SYS             STUDENT_INFO    STU_NAME        姓名

SYS             STUDENT_INFO    EMAIL           邮箱

SYS             STUDENT_INFO    SEX             性别

SYS             STUDENT_INFO    AGE             年龄

SYS             STUDENT_INFO    CLASS_ID        班级编号

SYS             STUDENT_INFO    REGDATE         创建时间

 

7 rows selected.

 

SYS@orcl> select * from all_tab_comments where table_name='STUDENT_INFO';

 

OWNER           TABLE_NAME      TABLE_TYPE  COMMENTS

--------------- --------------- ----------- -------------------------

SYS             STUDENT_INFO    TABLE       学生信息表

 

参考网址：https://blog.csdn.net/pan_junbiao/article/details/79951180