HELPLIB.HLB  —  ORACLE_RDB72, System Tables, RDB$CONSTRAINT_RELATIONS
    The RDB$CONSTRAINT_RELATIONS system table lists all tables that
    participate in a given constraint. The following table provides
    information on the columns of the RDB$CONSTRAINT_RELATIONS system
    table.

                                Data
    Column Name                 Type      Summary Description

    RDB$CONSTRAINT_NAME         char(31)  The system-wide unique name
                                          of the constraint.
    RDB$RELATION_NAME           char(31)  The name of a table
                                          involved in the constraint.
    RDB$FLAGS                   integer   Flags.
    RDB$CONSTRAINT_CONTEXT      integer   The context variable of
                                          the table involved in the
                                          constraint.
    RDB$SECURITY_CLASS          char(20)  Reserved for future use.

1  –  RDB$FLAGS

    Represents flags for RDB$CONSTRAINT_RELATIONS system table.

    Bit
    Position   Description

    0          Reserved for future use.
    1          Reserved for future use.
    2          If the constraint is on the specified table.
    3          If the constraint evaluates with optimization by dbkey
               lookup.
    4          If the constraint checks for existence.
    5          If the constraint checks for uniqueness.
    6          If the constraint needs to evaluate on store of
               specified table row.
    7          If the constraint need not evaluate on store of
               specified table row.
    8          If the constraint needs to evaluate on erase of
               specified table row.
    9          If the constraint need not evaluate on erase of
               specified table row.
Close Help