备注sql

-- Create tablecreate table IOID_SEQUENCE_T(  CLASS_NAME  VARCHAR2(30) not null,  REGION_ID   NUMBER(10) not null,  SEQ_ID      NUMBER(28) not null,  STEP_VALUE  NUMBER(9) not null,  MIN_VALUE   NUMBER(28) not null,  MAX_VALUE   NUMBER(28) not null,  DESCRIPTION VARCHAR2(1024))tablespace TS_HSS_DATA  pctfree 10  initrans 1  maxtrans 255  storage  (    initial 256    next 256    minextents 1    maxextents unlimited    pctincrease 0  );-- Add comments to the columns comment on column IOID_SEQUENCE_T.CLASS_NAME  is '类名(或表名)';comment on column IOID_SEQUENCE_T.REGION_ID  is '区域';comment on column IOID_SEQUENCE_T.SEQ_ID  is '序列值';comment on column IOID_SEQUENCE_T.STEP_VALUE  is '步长值';comment on column IOID_SEQUENCE_T.MIN_VALUE  is '最小值';comment on column IOID_SEQUENCE_T.MAX_VALUE  is '最大值';comment on column IOID_SEQUENCE_T.DESCRIPTION  is '字段描述';-- Create/Recreate indexes create unique index I1_IOID_SEQUENCE_T on IOID_SEQUENCE_T (CLASS_NAME, REGION_ID)  tablespace TS_HSS_INDX  pctfree 10  initrans 2  maxtrans 255  storage  (    initial 256K    next 128K    minextents 1    maxextents unlimited    pctincrease 0  );-- Grant/Revoke object privileges grant update on IOID_SEQUENCE_T to LS85_APP_PARA;grant update on IOID_SEQUENCE_T to LS85_SYS_PARA;