Modify sequence attributes

You can use the ALTER SEQUENCE statement to modify the attributes of a sequence except for the starting value, including its minimum value, maximum values, step size, and CYCLE attribute. Syntax:

ALTER SEQUENCE sequence_name
[MINVALUE value | NOMINVALUE]
[MAXVALUE value | NOMAXVALUE]
[INCREMENT BY value]
[CACHE value | NOCACHE]
[ORDER | NOORDER]
[CYCLE | NOCYCLE];