Important

The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.

DROP FUNCTION

Syntax

SQL

DROP FUNCTION [IF EXISTS] {function_name | database_name.function_name} [WITH ID <variant ID>] [FORCE]

Remarks

Only one function can be removed using the DROP FUNCTION command.
If DROP FUNCTION is executed for a function that does not exist, the following error occurs:
SQL
```
DROP FUNCTION myfunction;
ERROR 1998 (HY000): Function 'db1.myfunction' doesn't exist
```
However, if the IF EXISTS condition is used and the function does not exist, no error occurs:
SQL
```
DROP FUNCTION IF EXISTS myfunction;
Query OK, 0 rows affected (0.00 sec)
```
Specify the FORCE option to remove a function (UDF) created by an Extension. You must have the DROP EXTENSION permission to use this option.
This command causes implicit commits. Refer to COMMIT for more information.
Refer to the Permission Matrix for the required permissions.
If a function is overloaded, DROP FUNCTION requires the function's variant ID which is available in SHOW FUNCTIONS. Refer to Overloaded Functions and Stored Procedures for more information.

Examples

Drop a Function in the Current Database

The following example removes an existing function from the current database.

Refer to Overloaded Functions and Stored Procedures for an example of dropping an overloaded function.

SQL

SHOW FUNCTIONS;

+------------------+-----------------------+
| Functions_in_db1 | Function Type         |
+------------------+-----------------------+
| myfunction       | User Defined Function |
+------------------+-----------------------+
1 row in set (0.00 sec)

SQL

DROP FUNCTION myfunction;

SHOW FUNCTIONS;

Query OK, 0 rows affected (0.07 sec)

Dropping a Function in Another Database

The following example removes an existing function while connected to another database in your SingleStore cluster.

SQL

USE db1;

SHOW FUNCTIONS;

+------------------+-----------------------+
| Functions_in_db1 | Function Type         |
+------------------+-----------------------+
| myfunction       | User Defined Function |
+------------------+-----------------------+
1 row in set (0.00 sec)

SQL

USE db2;

DROP FUNCTION db1.myfunction;

Query OK, 0 rows affected (0.05 sec)

SQL

USE db1;

SHOW FUNCTIONS;

Query OK, 0 rows affected (0.07 sec)

Related Topics