Create Sequence 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. Next Value For Clause