DROP EXTERNAL FUNCTION
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Removes a user-defined function (UDF) declaration from a database. Available in gpre
, DSQL, and isql
.
DROP EXTERNAL FUNCTION name;
Important:
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
isql
, the semicolon is a terminating symbol for the statement, so it must be included.Argument | Description |
---|---|
<name> |
Name of an existing UDF |
Description: DROP EXTERNAL FUNCTION
deletes a UDF declaration from a database. Dropping a UDF declaration from a database does not remove it from the corresponding UDF library, but it does make the UDF inaccessible from the database. Once the definition is dropped, any applications that depend on the UDF will return run-time errors.
A UDF can be dropped by its declarer, the SYSDBA
user, or any users with operating system root privileges.
Example: This isql
statement drops a UDF:
DROP EXTERNAL FUNCTION TOPS;