Background documentationSequence Name (sequence_name) Locate this document in the navigation structure

 

A sequence name (sequence_name) identifies a sequence of values.

Structure

Syntax Syntax

  1. <sequence_name> ::=
      <identifier>
End of the code.

The identifier may not exceed 32 characters in length.

Examples

SQL Tutorial, Number Generators for Tables

Explanation

A sequence is a series of values generated in accordance with certain rules. Among other things, you can define the step width between these values.

Sequences can be used to generate unique values. These are not uninterrupted, because values generated within a transaction that has been rolled back cannot be used again.