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

  1. 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:

    1. orientdb> ALTER SEQUENCE idseq START 1000

For more information, see