Switch to: V12V11V10V9V8V7V6V5

Create Procedure Dialog Help

To create a new procedure, invoke Contextual Menu for Database from Schema Editor, go to sub menu Create, and choose Procedure.

Create Procedure Dialog

  • Name - Name of the procedure.
  • Function - Defines kind of routine.
  • Result Type - Defines datatype of result value (Only for functions).
  • Parameters - Defines list of routines parameters.
    • Name - Name of the parameter.
    • Direction - Direction of the parameter (IN/OUT/INOUT).
    • Type - Data type of the parameter.
    • Plus - Add parameter.
    • Minus - Remove selected parameter.
    • Arrows - Change order of parameters.
  • Procedure text - body of procedure.
  • Preview - Shows SQL query for creation of current routine.

Preview Procedures Text