Purpose

The Create Sequence statement creates an auto-incrementing sequence for a local table.

Syntax

CREATE SEQUENCE sequence_name [AS {INTEGER | BIGINT}] [START WITH start_value] [INCREMENT BY increment_value]

where:

sequence_name
specifies the name of the sequence. By default, the sequence type is INTEGER.
start_value
specifies the starting value of the sequence. The default start value is 0.
increment_value
specifies the value of the increment; the value must be a positive integer. The default increment is 1.