DROP PROCEDURE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Removes a single stored procedure from the specified database.
Syntax
DROP PROCEDURE [IF EXISTS] { procedure_name | database_name.procedure_name }
Remarks
-
Only one stored procedure can be removed using the
DROP PROCEDURE
command. -
If
DROP PROCEDURE
is executed for a procedure that does not exist, the following error will occur:DROP PROCEDURE myprocedure;ERROR 1998 (HY000): Function 'db1.myprocedure' doesn't exist
-
However, if the
IF EXISTS
condition is used and the procedure does not exist, no error will occur:DROP PROCEDURE IF EXISTS myprocedure;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 Procedure in the Current Database
The following example removes an existing function from the current database.
SHOW FUNCTIONS;
+------------------+------------------+
| Functions_in_db1 | Function Type |
+------------------+------------------+
| myprocedure | Stored Procedure |
+------------------+------------------+
1 row in set (0.00 sec)
DROP PROCEDURE myprocedure;SHOW FUNCTIONS;
Query OK, 0 rows affected (0.07 sec)
Dropping a Procedure in Another Database
The following example removes an existing stored procedure while connected to another database in your SingleStore cluster.
USE db1;SHOW FUNCTIONS;
+------------------+------------------+
| Functions_in_db1 | Function Type |
+------------------+------------------+
| myprocedure | Stored Procedure |
+------------------+------------------+
1 row in set (0.00 sec)
USE db2;DROP PROCEDURE db1.myprocedure;USE db1;SHOW FUNCTIONS;
Query OK, 0 rows affected (0.07 sec)
Related Topics
Last modified: May 22, 2023