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
|