ALTER SEQUENCE statement

The ALTER SEQUENCE statement can be used to change a sequence in any of these ways:

Restarting the sequence
Changing the increment between future sequence values
Setting or eliminating the minimum or maximum values
Changing the number of cached sequence numbers
Changing the attribute that determines whether the sequence can cycle or not
Changing whether sequence numbers must be generated in order of request

Invocation

This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is in effect for the package (SQLSTATE 42509).

Authorization

The privileges held by the authorization ID of the statement must include at least one of the following:

ALTE

it

ALTER SEQUENCE statement

Invocation

Authorization