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.
Additional Information:
explode
extract