User-defined Functions

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure >

User-defined Functions

DatabaseSpy supports user-defined functions and displays them in a separate folder on the schema/database level. For each function, a Parameters sub-folder is provided where the function's parameters and their data types are listed.

ob_functions

Functions can be added to the favorites. Some maintenance options applicable to functions are available through the context menu (see Generating SQL Statements). Please note that functions are not supported in Access databases.

 

Be sure to always add the schema prefix to the function name when you select a function.


© 2019 Altova GmbH