Column name
|
Data type
|
Description
|
SEQUENCE_SYSID
|
INTEGER
|
System identifier of the sequence. |
IS_UNIQUE
|
CHAR(3)
|
One of:
"YES" = the sequence will yield unique values
"NO" = the sequence may repeat itself. |
START_VALUE
|
INTEGER
|
The initial value of the sequence. |
CURRENT_VALUE
|
INTEGER
|
The current value of the sequence. |
MAX_VALUE
|
INTEGER
|
The maximum value of the sequence. |
INCREMENT_VALUE
|
INTEGER
|
The increment value of sequence. |
IS_EXHAUSTED
|
CHAR(3)
|
One of:
"YES" = the series of values defined by the sequence is exhausted
"NO" = the series of values defined by the sequence is not exhausted. |
CYCLES
|
INTEGER
|
Number of times the maximum value of the sequence is exceeded. |
