ALTER SEQUENCE

Modifies the definition of an existing sequence in the database.

Syntax

ALTER SEQUENCE sequence-name
[ INCREMENT BY integer
| RESTART WITH integer
| NOMAXVALUE
| MAXVALUE integer
| NOMINVALUE
| MINVALUE integer
| CYCLE
| NOCYCLE
| CACHE integer
| NOCACHE
| ORDER
| NOORDER
]