oralce 新增表 表名 字段 说明

1.添加表

create table  student(
 id  number primary key,
 name varchar2(100),
 sex varchar2(10),
class varchar2(50)
)

2.添加表名说明

comment on table student is ‘学生信息表’

3.添加字段说明

comment on column student.id is '主键';
comment on column student.name is '名称';
comment on column student.sex is '性别';
comment on column student.class is '班级';