How can we drop a MySQL stored procedure?

If we have ALTER ROUTINE privileges for the procedure then with the help of DROP PROCEDURE statement we can drop a MySQL stored procedure. To demonstrate it, we are dropping a stored procedure named ‘coursedetails’ as follows −

mysql> DROP PROCEDURE coursedetails;
Query OK, 0 rows affected (0.68 sec)

The above query will drop the procedure named ‘coursedetails’. It can be confirmed by running the statement SHOW CREATE PROCEDURE which will return an error because the procedure does not exist.

Daniol Thomas

Published on 21-Feb-2018 10:15:29

• Related Questions & Answers
• How can we alter a MySQL stored procedure?
• How can we invoke MySQL stored procedure?
• How can we write MySQL handler in a stored procedure?
• How can a MySQL stored procedure call another MySQL stored procedure inside it?
• How can we perform ROLLBACK transactions inside a MySQL stored procedure?
• How can we handle a result set inside MySQL stored procedure?
• What is stored procedure and how can we create MySQL stored procedures?
• How can we perform START transactions inside MySQL stored procedure?
• How can we perform COMMIT transactions inside MySQL stored procedure?
• How can we create MySQL stored procedure to calculate the factorial?
• How can we use prepared statements in a stored procedure?
• How can we see the source code of a particular MySQL stored procedure?
• How can we write MySQL stored procedure to select all the data from a table?
• How can we alter a MySQL stored function?
• How MySQL IF statement can be used in a stored procedure?