ALTER SEQUENCE

Modifies the properties of an existing sequence.

Basic Syntax

ALTER SEQUENCE [IF EXISTS] sequence_name
    [RESTART WITH restart_value]
    [INCREMENT BY increment_value]
    [MINVALUE min_value | NO MINVALUE]
    [MAXVALUE max_value | NO MAXVALUE]
    [CYCLE | NO CYCLE];

Examples

ALTER SEQUENCE my_seq RESTART WITH 50 INCREMENT BY 10;