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:
Insert Templates
|
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
|
Update Templates
|
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
|
Delete Templates
|
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
|