PowerDesigner Pre-defined Procedure Templates

The pre-defined DBMS templates provided with PowerDesigner generate SQL insert, delete, update, and select statement procedures.

You can modify the code of these pre-defined procedure templates, but they cannot be deleted or renamed.

The following templates, which create procedures linked to tables, are provided for those databases that support them:

Template type

Generates procedure executing...

DeleteProcedure

a SQL Delete statement

InsertProcedure

a SQL Insert statement

SelectProcedure

a SQL Select statement

UpdateProcedure

a SQL Update statement