START WITH

`START WITH` Option

The optional START WITH clause allows you to specify an initial value other than 1.This value is the first value generated when using NEXT VALUE FOR sequence.

`INCREMENT` Option

The optional INCREMENT clause allows you to specify another non-zero step value than 1.

Warning

The SQL standard specifies that if INCREMENT is specified with a negative value, and START WITH is not specified, that the first value generated should be the maximum of the column type (e.g. 2³¹ - 1 for INTEGER).Instead, Firebird will start at 1.

START WITH

START WITH Option

INCREMENT Option

`START WITH` Option

`INCREMENT` Option