- Developer Preview
DROP FUNCTIONstatement enables you to delete a user-defined function.
This is a Developer Preview feature, intended for development purposes only. Do not use this feature in production. No Enterprise Support is provided for Developer Preview features.
Refer to Developer Preview Mode for more information.
drop-function ::= DROP FUNCTION name
The name of the function. This may be an unqualified identifier, such as
`func-1`, or a qualified identifier with a namespace, such as
|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.|
This statement deletes an inline function called
DROP FUNCTION celsius;
You can run the following query to check that the function is no longer available.
SELECT * FROM system:functions;
This statement deletes an external function called
add in a library called
add function and
math library are still available.
$ curl -v -X GET http://localhost:8093/functions/v1/libraries -H 'content-type: application/json' -u Administrator:password