D.28 RDB$REF_CONSTRAINTS

RDB$REF_CONSTRAINTS stores the attributes of the referential constraints — Foreign Key relationships and referential actions.

Column Name Data Type Description
RDB$CONSTRAINT_NAME CHAR(63) Foreign key constraint name, defined by the user or automatically generated by the system
RDB$CONST_NAME_UQ CHAR(63) The name of the primary or unique key constraint linked by the REFERENCES clause in the constraint definition
RDB$MATCH_OPTION CHAR(7) Not used. The current value is FULL in all cases
RDB$UPDATE_RULE CHAR(11) Referential integrity actions applied to the foreign key record(s) when the primary (unique) key of the parent table is updated: RESTRICT, NO ACTION, CASCADE, SET NULL, SET DEFAULT
RDB$DELETE_RULE CHAR(11) Referential integrity actions applied to the foreign key record(s) when the primary (unique) key of the parent table is deleted: RESTRICT, NO ACTION, CASCADE, SET NULL, SET DEFAULT