ALTER SEQUENCE
ALTER SEQUENCE sequence‑name
[RESTART WITH value]
[INCREMENT BY value]
Access requirements
Database user
Usage
Use the ALTER SEQUENCE statement to set the sequence value dynamically.
Parameters, clauses, keywords, and variables
▪ RESTART WITH: Sequence is restarted with the given sequence number, and the following sequence number is value + 1.
Note ALTER SEQUENCE ... RESTART WITH provides the same functionality as the non-standard statement, SET SEQUENCE, see
SET SEQUENCE.
▪ INCREMENT BY: Next returned value is current‑value + value.
▪ value: A positive integer.
Examples
Change sequence SEQ1 to restart from 45.
ALTER SEQUENCE SEQ1 RESTART WITH 45;
Change sequence SEQ2 to continue with increments of 5.
ALTER SEQUENCE SEQ2 INCREMENT BY 5;
Go up to