Chapter 5 Building Triggers and Procedures
The pre-defined DBMS templates provided with PowerDesigner control referential integrity constraints for insert, update, and delete events. Depending on the current DBMS, there is a before and after event template for each trigger type.
You can modify the code of these pre-defined trigger templates, but they cannot be deleted or renamed.
The following templates types exist, but may vary by DBMS:
| Template type | Generates trigger/procedure executing... |
|---|---|
InsertTrigger
|
With insert |
BeforeInsertTrigger
|
Before insert |
AfterInsertTrigger
|
After insert |
InsertProc
|
When called by InsertTrigger
|
BeforeInsertProc
|
When called by BeforeInsertTrigger
|
AfterInsertProc
|
When called by AfterInsertTrigger
|
| Template type | Generates trigger/procedure executing... |
|---|---|
UpdateTrigger
|
With update |
BeforeUpdateTrigger
|
Before update |
AfterUpdateTrigger
|
After update |
UpdateProc
|
When called by UpdateTrigger
|
BeforeUpdateProc
|
When called by BeforeUpdateTrigger
|
AfterUpdateProc
|
When called by AfterUpdateTrigger
|
| Template type | Generates trigger/procedure executing... |
|---|---|
DeleteTrigger
|
With delete |
BeforeDeleteTrigger
|
Before delete |
AfterDeleteTrigger
|
After delete |
DeleteProc
|
When called by DeleteTrigger
|
BeforeDeleteProc
|
When called by BeforeDeleteTrigger
|
AfterDeleteProc
|
When called by AfterDeleteTrigger
|
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |