Chapter 6 Building Triggers and Procedures
When you write a stored procedure, PowerDesigner automatically creates dependencies to any table, view, procedure, or database package referenced in the procedure. These dependencies are taken into account when performing an impact analysis prior to deleting the procedure or an object on which it depends. If the procedure has a symbol in your diagram, then any dependencies will be shown graphically by way of arrows linking the procedure to these objects.
The diagram below shows a procedure, ProcChangeLocation, which is dependent on a number of other objects:
The Extended Dependencies tab of the procedure property sheet lists the objects upon which the procedure depends. The stereotype <<DBCreateAfter (computed)>> specifies that PowerDesigner has determined that the procedure can only be created after these objects.
The Dependencies tab of the Employee table property sheet shows that ProcChangeLocation is dependent upon it.
If you were to perform an impact analysis prior to deleting the Employee table, you would be warned of the dependency of the procedure upon it.
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |