DB2 官方文档中并没有对此选项做出很好的解释,我们看看Oracle的这个选项:
CREATE SEQUENCE command
PURPOSE:
To create a sequence. A sequence is a database object from which
multiple users may generate unique integers. You can use sequences
to automatically generate primary key values.
SYNTAX:
CREATE SEQUENCE [schema.]sequence
[INCREMENT BY integer]
[START WITH integer]
[MAXVALUE integer | NOMAXVALUE]
[MINVALUE integer | NOMINVALUE]
[CYCLE | NOCYCLE]
[CACHE integer | NOCACHE]
[ORDER | NOORDER]
where:
schema
is the schema to contain the sequence. If you omit schema, Oracle
creates the sequence in your own schema.
sequence
is the name of the sequence to be created.
INCREMENT BY
specifies the interval between sequence numbers. This value can be
any positive or negative Oracle integer, but it cannot b