You can use Unified Modeling Language (UML) class diagrams
to create Structured Query Language (SQL) stored procedures and
add them to databases.
In your project, you must have a database diagram
that already has database and schema objects open in the diagram editor
before you can create stored procedures.
To create a stored procedure:
- In the Palette, click Stored Procedure.
- Click inside the diagram editor where you want to place
the new stored procedure.
- Follow the instructions in the New SQL Stored
Procedure wizard.
- Click Finish.