创建序列如下:
CREATE SEQUENCE 序列名称 AS INTEGER
MINVALUE 1 MAXVALUE 99999999
START WITH 301 INCREMENT BY 1
CACHE 100 CYCLE NO ORDER;
修改序列步增:
ALTER SEQUENCE CMIS_SEQ_0002_1021 INCREMENT BY 1; --步增
修改序列的起始数:
ALTER SEQUENCE CMIS_SEQ_PSP_001 RESTART WITH 1;