ALTER SEQUENCE
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
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.