PowerDesigner provides support for modeling triggers and stored procedures.
Triggers (PDM)
A trigger is a segment of SQL code associated with a table or a view, which is invoked automatically whenever there is an attempt to modify data in the associated table or view with an insert, delete, or update command.
DBMS Triggers (PDM)
A DBMS trigger is not associated with any table or view, and fires on modifications to the database structure itself, such as the creation or dropping of a table or events like startup, shutdown, login etc.
Trigger Templates (PDM)
PowerDesigner trigger templates and template items allow you to create triggers in a modular reusable fashion.
Trigger Template Items (PDM)
Trigger template items are named reusable blocks of script that can be inserted into trigger templates or triggers.
Procedure Templates (PDM)
PowerDesigner procedure templates allow you to create procedures in a modular reusable fashion.
Creating SQL/XML Queries with the Wizard
You can use the SQL/XML Wizard to insert a SQL/XML query in the definition of a trigger, stored procedure, or function to store or retrieve data, in an XML format, from relational databases supporting SQL/XML. The wizard, allows you to select tables and views from a PDM to build a mapped XML model. This XML model (which does not appear in the workspace) is used to generate SQL/XML queries from global elements.