Edit the stored procedure/function definition under the Definition tab. Definition consists of a valid SQL procedure statement. This can be a simple statement such as SELECT or INSERT, or it can be a compound statement written using BEGIN and END. Compound statements can contain declarations, loops, and other control structure statements.

Parameter
Define stored procedure/function parameter.

Return Type
This text box will be enabled only for creating a stored function. It indicates the return type of the function.

Type
Select the stored routines you wish to create from the drop-down list, i.e. Procedure and Function.