Alter a sequence

You can alter a user sequence by resetting any sequence option, including the name and owner of the sequence. To change the starting value, use the RESTART WITH option.

To alter a sequence, use the ALTER SEQUENCE statement and specify the options in any order.

ALTER SEQUENCE <sequence name> <options>

Where the options are the following:

OWNER to <new owner>
RENAME TO <new sequence name>
RESTART WITH <start value>
INCREMENT BY <increment>
no minvalue | minvalue <minimum value>
no maxvalue | maxvalue <maximum value>
cycle | no cycle

If you alter a sequence while a sequence is in use by a running query, the system waits for the transaction of the running query to complete before it alters the sequence. This process is similar to the way the system handles attempts to drop a table that is in use by a running query.