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.