|
The General tab of the System Trigger property sheet has the following components:
Name Shows the name of the foreign key constraint to which the system trigger applies.
Type Shows the type of object.
Foreign table Shows the table containing the foreign key.
Primary table Shows the table containing the primary key or unique constraint in the foreign key relationship.
Event Shows which kind of event, Update Columns or Delete, causes the system trigger to execute.
Timing Shows whether the trigger executes before or after the event.
Action Shows which of the available referential integrity actions is used for updates and deletes of the primary key:
Set null Sets all foreign keys that reference the modified primary key to NULL.
Set default Sets all foreign keys that reference the modified primary key to the default value for that column (as specified in the table definition).
Cascade When used with ON UPDATE, this action updates all foreign keys that reference the updated primary key to the new value. When used with ON DELETE, this action deletes all rows containing foreign keys that reference the deleted primary key.