dyok 发表于 2016-11-15 07:14:29

DB2中创建SEQUENCE

　　创建SEQUENCE
：

CREATE SEQUENCE NAME_XXX_SEQAS INT START WITH 1000 INCREMENT BY 1 MINVALUE 1
NO MAXVALUE NO CYCLE NO CACHE ORDER;
　　查询SEQUENCE
：

SELECT NEXTVAL FOR NAME_XXX_SEQ FROM SYSIBM.SYSDUMMY1;
页: [1]
查看完整版本: DB2中创建SEQUENCE