Changes the sequence. Using this parameter you can change all sequence options, except for the sequence type.
This feature was introduced in version 2.2.
ALTER SEQUENCE <sequence> [START <start-point>] [INCREMENT <increment>] [CACHE <cache>] [CYCLE TRUE|FALSE] [LIMIT <limit_value>] [ASC|DESC]
<sequence>Defines the sequence you want to change.
STARTDefines the initial sequence value.
INCREMENTDefines the value to increment when it calls
CACHEDefines the number of values to cache, in the event that the sequence is of the type
CYCLEDefines if sequence will restart from
LIMITvalue reached. Default value is
LIMITDefines limit value sequence can reach. After limit value is reached cyclic sequences will restart from START value, while non cyclic sequences will throw message that limit is reached.
ASC | DESCDefines order of the sequence.
ASCdefines that next sequence value will be
currentValue + incrementValue, while
DESCdefines that next sequence value will be
currentValue - incrementValue(assuming that limit is not reached). Default value is
NOLIMITCancel previously defined
Alter a sequence, resetting the start value to
ALTER SEQUENCE idseq START 1000 CYCLE TRUE
For more information, see