The RDB$SEQUENCES system table contains information about each
sequence. The following table provides information on the columns
of the RDB$SEQUENCES system table.
Data
Column Name Type Summary Description
RDB$CREATED date vms Time sequence was created.
RDB$LAST_ALTERED date vms Last time sequence was
altered.
RDB$ACCESS_CONTROL list Access control list for
of byte this sequence.
varying
RDB$DESCRIPTION list Description provided for
of byte this sequence.
varying
RDB$START_VALUE bigint Starting value for the
sequence.
RDB$MINIMUM_SEQUENCE bigint Minimum value for the
sequence.
RDB$MAXIMUM_SEQUENCE bigint Maximum value for the
sequence.
RDB$NEXT_SEQUENCE_ bigint Next value available for
VALUE use for the sequence.
This column is a read
only COMPUTED BY column.
When the sequence is first
defined this column returns
NULL.
RDB$INCREMENT_VALUE integer Increment value for the
sequence. A positive
value indicates an
ascending sequence, and
a negative value indicates
a descending sequence.
RDB$CACHE_SIZE integer Number of sequence numbers
to allocate and hold in
memory. If one (1), then
NOCACHE was specified
and the values will be
allocated one at a time.
RDB$FLAGS integer Flags.
RDB$SEQUENCE_ID integer Unique number assigned to
this sequence object. This
value is for internal use
only.
RDB$SEQUENCE_NAME char(31) Unique name of the
sequence.
RDB$SEQUENCE_CREATOR char(31) Creator of this sequence.
1 – RDB$FLAGS
Represents flags for RDB$SEQUENCES system table.
Bit
Position Description
0 Sequence will cycle.
1 Sequence is ordered.
2 Sequence is random.
3 Indicates that this is a system sequence and may not be
dropped.
4 Indicates that there was no minimum value specified.
5 Indicates that there was no maximum value specified.
6 Indicates that this is a column IDENTITY sequence.
7 Indicates that this sequence will wait for locks.
8 Indicates that this sequence will not wait for locks.