シーケンス

• Oracle

CREATE SEQUENCE seq1
START WITH 1000
INCREMENT BY 1
NOCACHE
NOCYCLE;

• MySQL

※MySQLにシーケンスはない。AUTO_INCREMENTを使用する

• PostgreSQL

\ds+

CREATE SEQUENCE seq1 START 101;
CREATE SEQUENCE seq2 increment by 1 minvalue 1 maxvalue 100000 start with 1
cache 20 cycle ;

SELECT nextval('seq1');
SELECT nextval('seq2');

• SQL Server

CREATE SEQUENCE seq1
START WITH 1
INCREMENT BY 1 ;
GO
SELECT NEXT VALUE FOR seq1;
go

CREATE SEQUENCE dbo.seq2
AS decimal(3,0)
START WITH 125
INCREMENT BY 25
MINVALUE 100
MAXVALUE 200
CYCLE
CACHE 3
;

SELECT NEXT VALUE FOR seq2;
go

create table tab11
(col1 int default (next value for seq1) primary key, col2 int)
;