Chapter 5 Building Triggers and Procedures

Which Triggers are Rebuilt?

Whether you use the automatic model option or rebuild triggers manually, all triggers that are based on a trigger template are rebuilt. These include:

• The default PowerDesigner triggers that are used to maintain referential integrity between tables
• Any other triggers that you have created via a user-defined trigger template

User-defined triggers

When a trigger based on a trigger template is modified, it becomes user-defined. The Rebuild Triggers function does not create a trigger corresponding to a trigger template attached to a user-defined trigger if you select the "Preserve" mode.

If you wish to recreate a trigger based on the same trigger template you can:

• Click the User-defined button in the Definition page of the trigger property sheet to reset your edits. This removes the changes performed on the trigger and reapplies the trigger template
• Select <None> in the trigger template dropdown listbox in the Definition page of the trigger property sheet. This detaches the trigger template from the user-defined trigger. The next time you will rebuild triggers, a new trigger based on the previously mentioned trigger template will be created

For example, Trigger1 is based on template TrigTpl1. You modify Trigger1 so PowerDesigner turns it into a user-defined trigger. If you want to recreate a trigger based on TrigTpl1 you can click the User-defined button in the Definition page of the Trigger1 property sheet: you restore the trigger template code, but you lose the modifications on the trigger. You can also keep the changes performed on the trigger by selecting <None> in the trigger template dropdown listbox in the Definition page of the trigger property sheet. The trigger template is detached from the trigger and a new trigger based on this trigger template will be created the next time you rebuild triggers.

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