VMS Help  —  SQL72  System Tables, RDB$SEQUENCES
    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
RDB$FLAGS
Close Help