Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Removes a single stored procedure from the specified database.
DROP PROCEDURE [IF EXISTS] { procedure_name | database_name.procedure_name }
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)
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;
Query OK, 0 rows affected (0.05 sec)
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 DB cluster.
USE db1;
Database changed
SHOW FUNCTIONS;
+------------------+------------------+
| Functions_in_db1 | Function Type |
+------------------+------------------+
| myprocedure | Stored Procedure |
+------------------+------------------+
1 row in set (0.00 sec)
USE db2;
Database changed
DROP PROCEDURE db1.myprocedure;
Query OK, 0 rows affected (0.05 sec)
USE db1;
Database changed
SHOW FUNCTIONS;
Query OK, 0 rows affected (0.07 sec)
Related Topics