Model Database Functions

Database Functions are a feature that some DBMS products implement to provide users with a mechanism - as a routine - to extend the functionality of the database server. In the Database Builder, you create and define database Functions as individual objects.

Access     Tools | Database Builder | Right-click on Functions Package | Add new Function

A database Function element is immediately added to the Package, with the name highlighted for change. Type an appropriate name.

To define the database Function, double-click on it. The Function: <function name> dialog displays.

·The Database field defaults to the DBMS for which you are defining the database
·In the Notes field, type some notes on, or a description of, the Function
·In the Function definition field, type the full Function definition; the code editor provides Intelli-sense for basic SQL keywords and functions


To delete a database Function, right-click on the Function name and click on the Delete <function name> option. A prompt displays to confirm deletion of the Function and its contents; click on the Yes button.


·If you create a database Function element external to the Database Builder, in any part of the model other than the Functions Package, that Function element is automatically reassigned to the Functions Package
·Database Functions created as individual objects are represented in the model hierarchy in the Database Builder as Class element icons; if you have Functions as operations of a container Class (created external to the Database Builder) they are represented in the model hierarchy as Class element icons with a pink 'operation' icon in the bottom right corner


Learn more