SYSSEQUENCES
The syssequences system catalog table lists the
sequence objects that exist in the database. The syssequences table
has the following columns.
| Column | Type | Explanation |
|---|---|---|
| seqid | SERIAL | Code uniquely identifying the sequence object |
| tabid | INTEGER | Identifying code of the sequence as a table object |
| start_val | INT8 | Starting value of the sequence |
| inc_val | INT8 | Value of the increment between successive values |
| max_val | INT8 | Largest possible value of the sequence |
| min_val | INT8 | Smallest possible value of the sequence |
| cycle | CHAR(1) | Zero means NOCYCLE, 1 means CYCLE |
| restart_val | INT8 | Starting value of the sequence after ALTER SEQUENCE RESTART was run |
| cache | INTEGER | Number of preallocated values in sequence cache |
| order | CHAR(1) | Zero means NOORDER, 1 means ORDER |