Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$REF_CONSTRAINTS
Firebird Firebird Prev: RDB$PROCEDURE_PARAMETERSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$RELATIONS

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(31) Foreign key constraint name, defined by the user or automatically generated by the system
RDB$CONST_NAME_UQ CHAR(31) 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 th foreign key record[s] when the primary (unique) key of the parent table is deleted: RESTRICT, NO ACTION, CASCADE, SET NULL, SET DEFAULT

Prev: RDB$PROCEDURE_PARAMETERSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$RELATIONS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$REF_CONSTRAINTS