SEQUENCES
The SEQUENCES view contains one row for each sequence.
The following table describes the columns in the view:
| Column Name | Data Type | Description |
|---|---|---|
| SEQUENCE_CATALOG | VARCHAR(128) | Relational database name |
| SEQUENCE_SCHEMA | VARCHAR(128) | SQL schema that contains the sequence |
| SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
| DATA_TYPE | VARCHAR(128) | Type of the sequence |
| NUMERIC_PRECISION | INTEGER | The precision of the sequence type |
| NUMERIC_PRECISION_RADIX | INTEGER | Indicates if the precision specified
in column NUMERIC_PRECISION is specified as a number of binary or
decimal digits:
|
| NUMERIC_SCALE | INTEGER | All sequence data types use 0 scale |
| START_VALUE | DECIMAL(63,0) | Starting value of the sequence |
| MINIMUM_VALUE | DECIMAL(63,0) | Minimum value of the sequence |
| MAXIMUM_VALUE | DECIMAL(63,0) | Maximum value of the sequence |
| INCREMENT | INTEGER | Increment value of the sequence |
| CYCLE_OPTION | VARCHAR(3) | Identifies whether the sequence values
will continue to be generated after the minimum or maximum value has
been reached.
|
| DECLARED_DATA_TYPE | VARCHAR(128) Nullable
|
Reserved. Contains the null value. |
| DECLARED_NUMERIC_PRECISION | INTEGER Nullable
|
Reserved. Contains the null value. |
| DECLARED_NUMERIC_SCALE | INTEGER Nullable
|
Reserved. Contains the null value. |