SQL - ALTER `SEQUENCE`

Changes the sequence. Using this parameter you can change all sequence options, except for the sequence type.

This feature was introduced in version 2.2.

Syntax

ALTER SEQUENCE <sequence> [START <start-point>] [INCREMENT <increment>] [CACHE <cache>]

<sequence> Defines the sequence you want to change.
START Defines the initial sequence value.
INCREMENT Defines the value to increment when it calls .next().
CACHE Defines the number of values to cache, in the event that the sequence is of the type CACHED.

Examples

Alter a sequence, resetting the start value to 1000:
```
orientdb> ALTER SEQUENCE idseq START 1000
```

For more information, see

CREATE SEQUENCE

DROP SEQUENCE

Sequences and Auto-increment

SQL Commands.

Provide feedback