The DROP FUNCTION
statement enables you to delete a user-defined function.
RBAC Privileges
To manage global internal functions, you must have the Manage Global Functions role. To manage scoped internal functions, you must have the Manage Scope Functions role, with permissions on the specified bucket and scope.
To manage global external functions, you must have the Manage Global External Functions role. To manage scoped external functions, you must have the Manage Scope External Functions role, with permissions on the specified bucket and scope.
For more details about user roles, see Authorization.
Syntax
drop-function ::= 'DROP' 'FUNCTION' function ( 'IF' 'EXISTS' )?
- function
-
(Required) Refer to Function Name below.
Function Name
function ::= ( namespace ':' ( bucket '.' scope '.' )? )? identifier
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 an external user-defined function, the JavaScript 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 the JavaScript library and the JavaScript function, you must use the SQL++ Functions REST API. For details, refer to Functions REST API.
Examples
This statement deletes an inline function called celsius
.
DROP FUNCTION celsius;
You can run the following query to check that the function is no longer available.
SELECT * FROM system:functions;
These statements delete two external functions:
-
A function called
geohash
, which depends on the JavaScriptencodeGeoHash
function in thegeohash-js
library; -
A function called
adjacent
, which depends on the JavaScriptcalculateAdjacent
function in thegeohash-js
library.
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.
curl -v -X GET \
http://localhost:8093/evaluator/v1/libraries/geohash-js \
-u Administrator:password
Related Links
-
To create user-defined functions, refer to CREATE FUNCTION.
-
To execute user-defined functions, refer to EXECUTE FUNCTION.
-
To include user-defined functions in an expression, refer to User-Defined Functions.
-
To view user-defined functions, refer to Monitor Queries.