Chapter 5 Building Triggers and Procedures

What are trigger templates?

PowerDesigner uses pre-defined trigger templates to create triggers to implement referential integrity between tables. Trigger templates exist for each type of trigger supported by the DBMS. Each template specifies:

• a Time – relevant to an event. One of:
  
  
  • After
  • Before
• an Event – that can occur to a table row. One of:
  
  
  • Delete
  • Insert
  • Update
• Code – that performs the trigger action. The code may contain references to trigger template items, which are re-usable blocks of script.

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