Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows

 

System Trigger Properties window: General tab

This tab 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 values to 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 Values   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.

 See also