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 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;

See Also

Advance To: