Chapter 6 Building Triggers and Procedures
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 |
Copyright (C) 2007. Sybase Inc. All rights reserved. |
![]() |