EPUB | CHM | PDF

Creating a Stored Procedure or Function

Top Previous Next

To create a new procedure (later on you can switch it to a stored function), click on the Stored Procedure (create-storedproc) icon on the Main tab of the Ribbon. Your mouse cursor will change its appearance. Click on the diagram area to create a new stored procedure. A rectangle with the name of the stored procedure will appear in the diagram:

diagram-stored-procedure

(Optional). To switch procedure to the function double click the routine rectangle. The Stored Routine Editor will be shown. Go to the Definition tab and select Function from the Routine type drop-down list. Click OK to save your changes.

diagram-stored-function

To edit parameters of the stored procedures and functions use Stored Routine Editor.

See also:
Diagram Objects: Stored Procedures and Functions | Stored Routine Editor | Stored Routine Manager