# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818607

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Modify a sequence.

Definition

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.