DROP EXTERNAL FUNCTION
Removes a user-defined function (UDF) declaration from a database. Available in
gpre, DSQL, and
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.
Name of an existing UDF
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.
isql statement drops a UDF:
DROP EXTERNAL FUNCTION TOPS;