The SYSSEQUENCES system table describes the sequence generators in the database.
| Column Name | Type | Length | Nullability | Contents |
|---|---|---|---|---|
| SEQUENCEID | CHAR | 36 | False | The id of the sequence generator. This is the primary key. |
| SCHEMAID | CHAR | 36 | False | The id of the schema which holds the sequence generator. There is a foreign key linking this column to SYS.SYSSCHEMAS.SCHEMAID. |
| SEQUENCENAME | VARCHAR | 128 | False | The name of the sequence generator. There is a unique index on (SCHEMAID, SEQUENCENAME). |
| SEQUENCEDATATYPE | org.apache.derby.catalog.TypeDescriptor
This class is not part of the public API. |
False | System type that describes the precision, length, scale, nullability, type name, and storage type of the data. | |
| CURRENTVALUE | BIGINT | True | The current value of the sequence generator. The initial value of this column is STARTVALUE. This column is NULL only if the sequence generator is exhausted and cannot issue any more numbers. | |
| STARTVALUE | BIGINT | False | The initial value of the sequence generator. | |
| MINIMUMVALUE | BIGINT | False | The minimum value of the sequence generator. | |
| MAXIMUMVALUE | BIGINT | False | The maximum value of the sequence generator. | |
| INCREMENT | BIGINT | False | The step size of the sequence generator. | |
| CYCLEOPTION | CHAR | 1 | False | If the sequence generator cycles, this value is 'Y'. If the sequence generator does not cycle, this value is 'N'. |