You can use the Trigger Templates dialog to change the template that is attached to an RI trigger type and view or change the macro code used by a particular template. When you change the template for a trigger, you can use a built-in template or a custom (user override) template.
To change the template that is attached to an RI trigger
The Trigger Templates dialog opens.
Displays the name of the database action and referential integrity action (for example, CHILD Delete CASCADE) that causes the associated trigger to fire.
Displays the name of the trigger template that is generated for the corresponding Referential Integrity Type.
Attaches the default trigger templates to the associated referential integrity type.
Detaches the selected trigger template from the associated referential integrity type. A trigger is only generated for the selected referential integrity type when it has an associated trigger template.
Lists the default built-in trigger templates.
Attaches the selected built-in trigger template to the selected referential integrity type.
Lists the user-defined trigger templates available in a model.
Attaches the selected user-defined trigger template to the selected referential integrity type.
Displays the name of the selected template. Enter a new name and click Add to add it to the User Override list.
Adds a user-defined trigger template to the User Override list.
Deletes the selected user-defined trigger template.
Opens the Macro Toolbox where you can select a macro to add to the trigger template.
Displays the template code in the selected built-in or user-defined trigger template.
Your changes are saved and the dialog closes. Click Cancel to close the dialog without saving your changes.
Copyright © 2013 CA.
All rights reserved.
|
|