DB2的常用Sequence操作
1)CREATE SEQUENCE 创建 CREATE SEQUENCE SEQ_NAME AS DECIMAL(27,0); CREATE SEQUENCE SEQ_NAME AS INT START WITH 1 INCREMENT BY 1 MINVALUE 1 NO MAXVALUE (MAXVALUE 999999999) NO CYCLE NO CACHE ORDER 2)ALTER SEQUENCE 修改 ALTER SEQUENCE SEQ_NAME RESTART WITH 1 3)DROP SEQUENCE 删除 DROP SEQUENCE SEQ_NAME RESTRICT 4)QUERY SEQUENCE 查询 SELECT NEXTVAL FOR SEQ_NAME FROM SYSIBM.SYSDUMMY1 |