| Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → System Tables → 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 Name | Data Type | Description |
|---|---|---|
| RDB$CONSTRAINT_NAME | CHAR(31) | Constraint name, defined by the user or automatically generated by the system |
| RDB$TRIGGER_NAME | CHAR(31) | For a CHECK constraint, it is the name of the trigger that enforces this constraint. For a NOT NULL constraint, it is the name of the table the constraint is applied to. For a foreign key constraint, it is the name of the trigger that enforces the ON UPDATE, ON DELETE clauses |
|
| Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → System Tables → RDB$CHECK_CONSTRAINTS |