Alter Sequence

The Alter Sequence statement resets the next value of an existing sequence.

NOTE: Indexes on remote tables cannot be created, altered or dropped. Indexes can only be defined on local tables by the driver.

Grammar

ALTER SEQUENCE sequence_name RESTART WITH value

where:

sequence_name specifies an existing sequence.

value specifies the next value to be returned through the Next Value For clause (see “Next Value For Clause”).