Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

DROP FUNCTION

  • reference
March 23, 2025
+ 12
The DROP FUNCTION statement enables you to delete a user-defined function.

Prerequisites

To manage …​ You must have …​

Global inline functions

Manage Global Functions role.

Scoped inline functions

Manage Scope Functions role, with permissions on the specified bucket and scope.

Global external functions

Manage Global External Functions role.

Scoped external functions

Manage Scope External Functions role, with permissions on the specified bucket and scope.

For more details about user roles, see Authorization.

Syntax

ebnf
ViewCopy
drop-function ::= 'DROP' 'FUNCTION' function ( 'IF' 'EXISTS' )?
Syntax diagram: refer to source code listing
function

Function Name

Function Name

ebnf
ViewCopy
function ::= ( namespace ':' ( bucket '.' scope '.' )? )? identifier
Syntax diagram: refer to source code listing

The name of the function. This is usually an unqualified identifier, such as func1 or `func-1`. In this case, the path to the function is determined by the current query context.

To delete a global function in a particular namespace, the function name must be a qualified identifier with a namespace, such as default:func1. Similarly, to delete a scoped function in a particular scope, the function name must be a qualified identifier with the full path to a scope, such as default:`travel-sample`.inventory.func1. Refer to Global Functions and Scoped Functions for more information.

The name of a user-defined function is case-sensitive, unlike that of a built-in function. You must delete the user-defined function using the same case that was used when it was created.

IF EXISTS Clause

The optional IF EXISTS clause enables the statement to complete successfully when the specified function doesn’t exist.

When the function does not exist within the specified context: [1]

  • If this clause is not present, an error is generated.

  • If this clause is present, the statement does nothing and completes without error.

Usage

When you drop a user-defined function whose definition is stored in an external library, the external library and function on which the user-defined function depended are not deleted. This enables you to create a new user-defined function with a different name, or a different number of parameters, using the same JavaScript library and function.

To change or delete an external library or the external function code, you must use the Query Workbench or the SQL++ Functions REST API.

When you drop a SQL++ managed user-defined function, the associated external function code is deleted also.

Examples

Example 1. Drop an inline function

This statement deletes an inline function called celsius.

sql++
Copy
DROP FUNCTION celsius;

You can run the following query to check that the function is no longer available.

sql++
Copy
SELECT * FROM system:functions;
Example 2. Drop a SQL++ managed user-defined function

This statement deletes a SQL++ managed user-defined function called add100.

sql++
Copy
DROP FUNCTION add100 IF EXISTS;

You can run the following query to check that the function is no longer available.

sql++
Copy
SELECT * FROM system:functions;
Example 3. Drop an external function

These statements delete two external functions:

  1. A function called geohash, which depends on the JavaScript encodeGeoHash function in the geohash-js library;

  2. A function called adjacent, which depends on the JavaScript calculateAdjacent function in the geohash-js library.

sql++
Copy
DROP FUNCTION geohash;

DROP FUNCTION adjacent;

You can run the following command to check that the JavaScript geohash-js library and the encodeGeoHash and calculateAdjacent functions are still available.

sh
Copy
curl -v -X GET \
http://localhost:8093/evaluator/v1/libraries/geohash-js \
-u Administrator:password
1. That is, you are dropping a global function, and the function does not exist within the specified namespace; or, you are dropping a scoped function, and the function does not exist within the specified scope.