SEQUENCES
The system table DOMAIN.SEQUENCES contains all the sequences for which the current user has privileges.
|
SCHEMANAME |
CHAR(32) |
Name of the schema of the sequence |
|
OWNER |
CHAR(32) |
Name of the owner of the sequence |
|
SEQUENCE_NAME |
CHAR(32) |
Name of the sequence |
|
MIN_VALUE |
FIXED(38) |
Minimum value of the sequence |
|
MAX_VALUE |
FIXED(38) |
Maximum value of the sequence |
|
INCREMENT_BY |
FIXED(38) |
Value by which the sequence is increased |
|
CYCLE_FLAG |
CHAR(1) |
Specifies whether the sequence starts again from the minimum value after the maximum value is reached (N | Y) |
|
ORDER_FLAG |
CHAR(1) |
Specifies whether the sequence values are allocated in the order of the request (Y | N) |
|
CACHE_SIZE |
FIXED(38) |
Number of sequence values that are loaded to the cache simultaneously |
|
LAST_NUMBER |
FIXED(38) |
Last sequence value stored |
|
CREATEDATE |
DATE |
Creation date of the sequence |
|
CREATETIME |
TIME |
Creation time of the sequence |
|
COMMENT |
CLOB |
Comment on the sequence |
Evaluating System Tables, SEQUENCES
SQL Reference Manual, Sequence Name (sequence_name)