The Stored Routine Editor is provided for altering stored procedures/functions. All the parameters of stored procedure are valid for stored function, so you can switch between them easily.
To open the the Stored Routine Editor, simply double-click a stored procedure or function on the diagram or select the Properties item from the context menu.
The Stored Routine Editor consists of several tabs, each of which will be described below.
This tab allows you to tune the basic properties of a stored procedure or function.
Stored Routine Name
Routine is deterministic
SQL Data Access
Stored routine definer
The Definition tab allows you to choose the routine type (stored procedure or function), determine the list of parameters, edit routine text.
Quick Create button
This tab allows you to set SQL statements, which will be executed before (use Begin tab) and after (use End tab) generation of the stored routine.
The Preview tab displays the SQL statement, which will be executed during the database generation. This statement is made up according to the changes you have made using previous tabs. Note, that the text within the editor is read-only.
The Notes tab allows you to define a description and an annotation for the edited stored routine. This properties will not affect the physical database, but they can be useful for your diagram development.
These options allow you to set the routine line and fill color for displaying on the diagram, different from the default colors.