DB2 Sequence

1. 可以循环；最大值可以等于最小值

2. 第一次nextval的值默认为1

 

创建:

create sequence <sequence_name> start with <minvalue> incremental by <interval>;

create sequence test start with 5 incremental by 5;

 

查看下一个值：

SELECT NEXT VALUE FOR <sequence name> FROM sysibm.sysdummy1;

 

使用：

inset into <table name> values (<sequence name>.nextval,...);

 

删除：

drop sequence <sequence_name>;