VMS Help  —  SQL72  System Tables, RDB$INTERRELATIONS
    The RDB$INTERRELATIONS system table contains information that
    indicates the interdependencies of objects in the database. The
    RDB$INTERRELATIONS table can be used to determine if an object
    can be dropped or if some other object depends upon its existence
    in the database. The following table provides information on the
    columns of the RDB$INTERRELATIONS system table.

                                Data
    Column Name                 Type      Summary Description

    RDB$OBJECT_NAME             char(31)  The name of the object
                                          that cannot be dropped or
                                          altered because it is used
                                          by some other entity in the
                                          database.
    RDB$SUBOBJECT_NAME          char(31)  The name of the associated
                                          sub-object that cannot be
                                          dropped or altered because
                                          it is used by another
                                          entity in the database.
    RDB$ENTITY_NAME1            char(31)  The name of the entity that
                                          depends on the existence
                                          of the object identified
                                          by the RDB$OBJECT_NAME and
                                          RDB$SUBOBJECT_NAME.
    RDB$ENTITY_NAME2            char(31)  If used, the name of the
                                          entity, together with
                                          RDB$ENTITY_NAME1, that
                                          depends on the existence
                                          of the object specified
                                          in RDB$OBJECT_NAME and
                                          RDB$SUBOBJECT_NAME.
    RDB$USAGE                   char(31)  The relationship among
                                          RDB$OBJECT_NAME,
                                          RDB$SUBOBJECT_NAME,
                                          RDB$ENTITY_NAME1, and
                                          RDB$ENTITY_NAME2.

                                          RDB$USAGE contains a short
                                          description.
    RDB$FLAGS                   integer   Flags.
    RDB$CONSTRAINT_NAME         char(31)  This column is the name
                                          of a constraint that is
                                          referred to from another
                                          system table. The value in
                                          this column equates to a
                                          value for the same column
                                          in the RDB$CONSTRAINTS
                                          system table.
    RDB$SECURITY_CLASS          char(20)  Reserved for future use.

1  –  RDB$FLAGS

    Represents flags for RDB$INTERRELATIONS system table.

    Bit
    Position   Description

    0          Entity is a module.
    1          Object is a module.
    2          Entity is a routine.
    3          Object is a routine.
    4          Entity is a trigger.
    5          Object is a trigger.
    6          Entity is a constraint.
    7          Object is a constraint.
    8          Reserved.
    9          Reserved.
    10         Reserved.
    11         Reserved.
    12         Reserved.
    13         Reserved.
    14         Entity is a sequence.
    15         Object is a sequence.
Close Help