Alter Sequence
Purpose
The Alter Sequence statement resets the next value of an existing sequence.
Syntax
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").
Notes
Indexes on remote tables cannot be created, altered or dropped. Indexes can only be defined on local tables by the driver.
