删除一个sequence:
sql 代码
- DROP SEQUENCE [USER.][SEQUENCE_NAME];
例如:
sql 代码
- DROP SEQUENCE HIBERLAB.HIBERNATE_SEQUENCE;
新建一个sequence:
sql 代码
- CREATE SEQUENCE [USER.][SEQUENCE_NAME]
- START WITH [START_NUMBER]
- MAXVALUE [MAX_NUMBER]
- MINVALUE [MIN_NUMBER]
- NOCYCLE
- CACHE [CACHE_SIZE]
- NOORDER;
例如:
sql 代码
- CREATE SEQUENCE HIBERLAB.HIBERNATE_SEQUENCE
- START WITH 61
- MAXVALUE 999999999999999999999999999
- MINVALUE 1
- NOCYCLE
- CACHE 20
- NOORDER;
修改一个sequence:
sql 代码
- ALTER SEQUENCE [USER.][SEQUENCE_NAME]
- INCREMENT BY [INCREMENT_SIZE]
- MINVALUE [MIN_NUMBER]
- MAXVALUE [MAX_NUMBER]
- CACHE [CACHE_SIZE]
- NOCYCLE NOORDER
例如:
sql 代码
- ALTER SEQUENCE HIBERLAB.HIBERNATE_SEQUENCE INCREMENT BY 1 MINVALUE 1 MAXVALUE 999999999999999999999999998 CACHE 20 NOCYCLE NOORDER