Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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.
Notes
| · | 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
