skip to main content
Supported SQL Statements and Extensions : Alter Sequence
  

Try DataDirect Drivers Now

Alter Sequence

Purpose

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").