Sequence Name (sequence_name)

Show TOC

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

Structure

Syntax Syntax

```
<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.

More Information

CREATE SEQUENCE Statement

CREATE SYNONYM Statement

DROP SEQUENCE Statement

SQL Tutorial, Number Generator for a Single Table Column