Online Documentation for SQL Manager for InterBase/Firebird

SQL Functions

An SQL function is a program (the function body) that can be invoked by using zero or more input values (arguments) to a single value (the result). A Function can be stored as a database object providing reusable code.

SQL Function Editor allows you to define user-defined function properties. It opens automatically when you declare a new user-defined function and is available on editing an existing one.

To open an SQL Function Editor, double-click it in the DB Explorer tree.

• Using Navigation bar and Toolbar
• Creating/editing SQL function
• Managing parameters\arguments\variables
• Specifying input parameters
• Browsing object dependencies
• Setting object permissions
• Editing object description
• Viewing DDL definition