Oracle 中建表后添加备注

--------------------------------------------------------1：建表语句----------------------------------------------------

create table EMP_TEST

(

  EMPNO NUMBER(4) PRIMARY KEY,

  ENAME VARCHAR2(10),

  JOB VARCHAR2(9),

  MGR NUMBER(4),

  HIREDATE DATE,

  SAL NUMBER(7,2),

  DEPNO NUMBER(4)

);

--------------------------------------------------------2：添加表注释--------------------------------------------------

COMMENT ON TABLE EMP_TEST IS '学生信息表';

--------------------------------------------------------3：添加字段注释------------------------------------------------

COMMENT ON COLUMN EMP_TEST.EMPNO IS '学号';

COMMENT ON COLUMN EMP_TEST.ENAME IS '姓名';

COMMENT ON COLUMN EMP_TEST.JOB IS '邮箱';

COMMENT ON COLUMN EMP_TEST.MGR IS '性别';

COMMENT ON COLUMN EMP_TEST.HIREDATE IS '入职日期';

COMMENT ON COLUMN EMP_TEST.SAL IS '薪资';

COMMENT ON COLUMN EMP_TEST.DEPNO IS '部门编号';