读书人

DB2中创办SEQUENCE

发布时间: 2012-09-29 10:30:01 作者: rapoo

DB2中创建SEQUENCE

创建SEQUENCE:

CREATE SEQUENCE NAME_XXX_SEQ  AS 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;

?

?

?

读书人网 >其他数据库

热点推荐