RDB$REF CONSTRAINTS
From InterBase
Go Up to System Tables
RDB$REF_CONSTRAINTS stores referential integrity constraint information.
Column name | Data type | Length | Description |
---|---|---|---|
RDB$3CONSTRAINT_NAME |
CHAR |
67 |
Name of a referential constraint |
RDB$CONST_NAME_UQ |
CHAR |
67 |
Name of a referenced PRIMARY KEY or UNIQUE constraint |
RDB$MATCH_OPTION |
CHAR |
7 |
Reserved for later use; currently defaults to FULL |
RDB$UPDATE_RULE |
CHAR |
11 |
Specifies the type of action on the foreign key when the primary key is updated; values are RESTRICT, NO ACTION, CASCADE, SET NULL, or SET DEFAULT |
RDB$DELETE_RULE |
CHAR |
11 |
Specifies the type of action on the foreign key when the primary key is DELETED; values are RESTRICT, NO ACTION, CASCADE, SET NULL, or SET DEFAULT |