Store procedures allow you to build complicated applications through a variety of features.
- In the Navigator, expand the Databases, right-click a database or user, and click Show Procedures. A list of the procedures defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
-
In the Object List Viewer toolbar, click .
A Create Procedures property form opens in the Details view.
- In the form, enter values for the new stored procedure.
- [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new procedure.
- Click Commit.
- Click OK. The property form shows the properties of the new stored procedure.