Title: (Optional) Modify a sequence.
Course: Database Design and Management (Oracle) (10052) > Section: Creating Additional Database Objects

Modification should include using the ALTER SEQUENCE statement to change the increment, minimum and maximum values, cached numbers, and behavior of an existing sequence. The following syntax is required:

ALTER SEQUENCE <sequencename>
[INCREMENT BY n]
[START WITH s]
[MAXVALUE x / NOMAXVALUE]
[MINVALUE m / NOMINVALUE]
[CYCLE / NOCYCLE]
[CACHE c / NOCHACHE] [ORDER / NOORDER];

This statement affects only future sequence numbers used.