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>]
<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
Alter a sequence, resetting the start value to
ALTER SEQUENCE idseq START 1000
For more information, see