DROP FUNCTION
Descriptionβ
Delete a custom function.
Syntaxβ
DROP [ GLOBAL ] <function_name> ( <arg_type> )
Required Parametersβ
1. <function_name>
Specifies the name of the function to delete.
The function name needs to be exactly the same as the function name when the function was created.
2. <arg_type>
Specifies the argument list for the function to be deleted.
Parameter List Location You need to enter the data type of the location parameter.
Optional Parametersβ
1.GLOBAL
GLOBAL is an optional parameter.
If GLOBAL is set, the function is searched for globally and deleted.
If GLOABL is not entered, the function is searched for in the current database and deleted.
Access Control Requirementsβ
The user who executes this SQL command must have at least the following permissions:
| Privilege | Object | Notes |
|---|---|---|
| ADMIN_PRIV | Custom function | DROP is an administrative operation |
Usage Notesβ
- A function can be deleted only when its name and parameter types are identical
Examplesβ
DROP FUNCTION my_add(INT, INT)
DROP GLOBAL FUNCTION my_add(INT, INT)
