Create a Stored Procedure

How To:

To create a stored procedure as a UML Class, follow the steps below.

Step

Action

See Also

1

Open the required diagram.

 

2

From the Data Modeling page of the Toolbox (More tools | Data Modeling) drag the Procedure icon onto the diagram.

 

3

If the Properties dialog does not automatically display, double-click on the element.

 

4

In the Database field click on the drop-down arrow and select the target DBMS to model

The field displays the default database if it has already been set

 

5

In the Procedure definition field, type the entire procedure text.

 

6

Click on the OK button.

 

7

To rename the stored procedure, select the element, press (F2) and type the new name.

 

Example:

Procedure element