SHOW FUNCTIONS
From InterBase
Go Up to isql Command Reference
Lists all user-defined functions (UDFs) defined in the database or displays information about a specified UDF.
SHOW {FUNCTIONS | FUNCTION name};
Argument | Description |
---|---|
<name> |
Name of an existing UDF in the current database |
Options: To see a list of existing functions defined in the database, use SHOW FUNCTIONS
. To display information about a specific function in the current database, use SHOW FUNCTION
<function_name>. Output includes information previously defined by the DECLARE EXTERNAL FUNCTION
statement: the name of the function and function library, the name of the entry point, and the data types of return values and input arguments.
Example: The following UNIX
example lists all UDFs and then shows the definition of the MAXNUM()
function:
SHOW FUNCTIONS;
ABS MAXNUM
TIME UPPER_NON_C
UPPER
SHOW FUNCTION maxnum;
Function MAXNUM:
Function library is /usr/InterBase/lib/gdsfunc.so
Entry point is FN_MAX
Returns BY VALUE DOUBLE PRECISION
Argument 1: DOUBLE PRECISION
Argument 2: DOUBLE PRECISION