oracle中建表后添加注释

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

create table EMP
(
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 IS '学生信息表';

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

COMMENT ON COLUMN EMP.EMPNO IS '学号';
COMMENT ON COLUMN EMP.ENAME IS '姓名';
COMMENT ON COLUMN EMP.JOB IS '邮箱';
COMMENT ON COLUMN EMP.MGR IS '性别';
COMMENT ON COLUMN EMP.HIREDATE IS '入职日期';
COMMENT ON COLUMN EMP.SAL IS '薪资';
COMMENT ON COLUMN EMP.DEPNO IS '部门编号';

转载于:https://www.cnblogs.com/zja001/p/10283161.html