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
Notes

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