oracle创建表时添加表注释

CREATE TABLE t1(

id varchar2(32) primary key,

name VARCHAR2(32) ,

age VARCHAR2(32) 

)

添加表注释：

COMMENT ON table t1 IS '个人信息'

添加字段注释：

comment on column t1.id is 'id'

comment on column t1.name is '姓名'

comment on column t1.age is '年龄'

1、向现有表添加字段

alter table sch_schoolextinfo add (LASTYEARTHEQUALITY VARCHAR2(10))

alter table sch_schoolextinfo add (THEORYTRAINCOMNUM VARCHAR2(10))

2、添加注释

comment on column SCH_SCHOOLEXTINFO.LASTYEARTHEQUALITY is '上年度质量信誉考核情况'

SCH_SCHOOLEXTINFO -------> 表名字

LASTYEARTHEQUALITY--------> 字段名

commentoncolumnSIGNSUN_CUSTOMER.DISABLE_TYPEis'废弃原因'将备注添加到现有字段上commentontableSIGNSUN_CUSTOMERis'XXXX'将备注添加到现有表上

---