Syntax

DROP FUNCTION [IF EXISTS] { function_name | database_name.function_name }

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 will occur:

  SQL

  Copy

  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 will occur:

  SQL

  Copy

  DROP FUNCTION IF EXISTS myfunction;
  Query OK, 0 rows affected (0.00 sec)

• This command causes implicit commits. Refer to COMMIT for more information.

• Refer to the Permission Matrix for the required permission.

Examples

Dropping a Function in the Current Database

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

SHOW FUNCTIONS;

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

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.

USE db1;

SHOW FUNCTIONS;

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

USE db2;

DROP FUNCTION db1.myfunction;

Query OK, 0 rows affected (0.05 sec)

USE db1;

SHOW FUNCTIONS;

Query OK, 0 rows affected (0.07 sec)

Related Topics

• SHOW FUNCTIONS

• CREATE FUNCTION (UDF)

• CREATE FUNCTION (TVF)