Chapter 5 Building Triggers and Procedures

Trigger template property sheet Template Items tab

The Template Items tab list the template items that are defined in the trigger template and that will be generated when a trigger is generated from the template.

A template item that is deleted from the Template Items page is not deleted from the trigger template definition. You can therefore limit the template items available for generation by removing template items from the Template Item page, without having to remove them from the trigger template definition.

Rebuild triggers

When you use Rebuild Triggers to automatically create triggers for selected tables, the template items that are listed on this page are those available for generation. Whether they are generated or not depends on the following:

• Template items are generated in a trigger if they match the trigger implemented referential integrity defined for a reference attached to the table
• Template items are generated in a trigger if they are user-defined, regardless of trigger referential integrity constraints

Adding template items to trigger template definition

You can add any template item from the model or DBMS to the Trigger template definition by clicking an Add Trigger Item tool from the Definition page of the trigger template property sheet, and selecting a trigger item. It is automatically added to the Template Items page.

Copyright (C) 2005. Sybase Inc. All rights reserved.