SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
System Trigger property sheet
The General tab of the System Trigger property sheet has the following components:
Name Shows the name of the system trigger.
Type Shows the type of object.
Foreign table Shows the table containing the foreign key.
Primary table Shows the table containing the primary key in the foreign key relationship.
Event Shows which kind of event, Insert, Delete, Update, or Update Columns, 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:
Restrict Generates an error and prevents the modification if an attempt to modify a referenced primary key value occurs. This is the default referential integrity action.
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.