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.

 

 
Set the Database Type

 

5

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

Languages supported

Options - Code Editors

 

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

Notes

Stored Procedures can also be defined under a single Class with the stereotype set to <<Stored Procedures>>, where each Stored Procedure is created as an operation under that Class; the scripting of these Stored Procedures can be viewed in the Operations dialog under Behavior

Learn more