Stored functions are routines that are available in 5.x and later versions of MySQL server. A Stored function is a set of SQL commands that returns the result and can be stored in the server. Once this is done, clients do not need to keep re-issuing the individual commands but can refer to the stored function instead.
Function Editor allows you to define function properties. It opens automatically when you create a new function and is available on editing an existing one.
To open a function in Function Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing function
- Browsing object dependencies
- Editing function description
- Viewing DDL definition
- Executing function