创建表:
CREATE TABLE CORPREPORTERINFO(
CRID NUMBER NOT NULL,
CORPID VARCHAR2(8) NOT NULL,
CRNAME VARCHAR2(20),
PRIMARY KEY(CRID,CORPID)
)
TABLESPACE "AGR";
添加表注释:
COMMENT ON table 表名 IS '上报员表';
添加字段注释:
CREATE TABLE CORPREPORTERINFO(
CRID NUMBER NOT NULL,
CORPID VARCHAR2(8) NOT NULL,
CRNAME VARCHAR2(20),
PRIMARY KEY(CRID,CORPID)
)
TABLESPACE "AGR";
添加表注释:
COMMENT ON table 表名 IS '上报员表';
添加字段注释:
comment on column 表名.字段名 is 'id';
如:
comment on column CORPREPORTERINFO.CORPID is '企业id';