ALTER SEQUENCE

SQL Guide : solidDB® SQL statements : ALTER SEQUENCE

ALTER SEQUENCE

ALTER SEQUENCE sequence-name
[RESTART WITH value]
[INCREMENT BY value]

where value is a numeric value.

Usage

The ALTER SEQUENCE statement sets the sequence value dynamically.

If you use the RESTART WITH option, the sequence is restarted with the given sequence number, and the following sequence number is value + 1.

If you use the INCREMENT BY option, the next returned value is current_value + value.

Note ALTER SEQUENCE sequence-name RESTART WITH value provides the same functionality as the non-standard statement, SET SEQUENCE sequence-name VALUE value, see SET SEQUENCE.

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;