DROP FUNCTION

The DROP FUNCTION command removes a single function from the specified database, including user-defined scalar-valued functions (UDFs) and user-defined table-valued functions (TVFs).

Syntax

DROP FUNCTION [IF EXISTS] {function_name | database_name.function_name} [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:

    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:

    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 Permissions Matrix for the required permissions.

Examples

Drop 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

Last modified:

Was this article helpful?