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.