D.4. RDB$CHECK_CONSTRAINTS

RDB$CHECK_CONSTRAINTS provides the cross-references between the names of system-generated triggers for constraints and the names of the associated constraints (NOT NULL constraints, CHECK constraints and the ON UPDATE and ON DELETE clauses in foreign key constraints).

Column NameData TypeDescription

RDB$CONSTRAINT_NAME

CHAR(31)

Constraint name, defined by the user or automatically generated by the system

RDB$TRIGGER_NAME

CHAR(31)

For CHECK constraints, the name of the trigger that enforces the constraint. For NOT NULL constraints, the name of the affected column. For foreign key constraints, the name of the trigger that enforces the ON UPDATE and ON DELETE clauses.