ALTER SEQUENCE statement

ALTER SEQUENCE  [ owner.] sequence-name
[ RESTART WITH signed-integer ]
[ INCREMENT BY signed-integer ]
[ MINVALUE signed-integer  |  NO MINVALUE  ]
[ MAXVALUE signed-integer  |  NO MAXVALUE  ]
[ CACHE integer  |  NO CACHE  ]
[ CYCLE  |  NO CYCLE ]

RESTART WITH Restarts the named sequence with the specified value.
INCREMENT BY Defines the amount the next sequence value is incremented from the last value assigned. The default is 1. Specify a negative value to generate a descending sequence. An error is returned if the INCREMENT BY value is 0.
MINVALUE Defines the smallest value generated by the sequence. The default is 1. An error is returned if MINVALUE is greater than ( 2^63-1) or less than -(2^63-1). An error is also returned if MINVALUE is greater than MAXVALUE.
MAXVALUE Defines the largest value generated by the sequence. The default is 1. An error is returned if MAXVALUE is greater than ( 2^63-1) or less than -(2^63-1).
CACHE Specifies the number of preallocated sequence values that are kept in memory for faster access.
CYCLE Specifies whether values should continue to be generated after the maximum or minimum value is reached.

If the named sequence cannot be located, an error message is returned.

Must have DBA authority or be the owner of the sequence and have RESOURCE authority.

None

SQL/2008 The ALTER SEQUENCE statement is part of optional SQL language feature T176 of the SQL/2008 standard. The CACHE clause is a vendor extension.

The following example sets a new maximum value for a sequence named Test:

ALTER SEQUENCE Test 
   MAXVALUE 1500;

ALTER SEQUENCE statement

Syntax

Parameters

Remarks

Permissions

Side effects

See also

Standards and compatibility

Example