Chapter 5 Building Triggers and Procedures

Rebuilding Triggers

You rebuild triggers in order to ensure that:

• They are attached to all tables joined by a reference where referential integrity is implemented by a trigger
• Any changes to a trigger template or trigger template item are cascaded down to all associated triggers

PowerDesigner can rebuild triggers either:

• Automatically, whenever a relevant change is made, if you have enabled the Automatically rebuild triggers model option
• Manually, when you select Tools→Rebuild Objects→Rebuild Triggers

The Rebuild Triggers function creates new triggers based on template items that correspond to trigger referential integrity defined for references and sequence implementation for columns.

The Rebuild Triggers function does not use pre-defined template items which are not applicable to trigger referential integrity or sequence implementation.

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