DROP PROCEDURE [IF EXISTS] sp_name
This statement is used to drop a stored procedure. That is, the
specified routine is removed from the server. You must have the
ALTER ROUTINE privilege for the routine. If the
automatic_sp_privileges server system variable is set, that privilege and
granted automatically to the routine creator - see Stored Routine Privileges.
IF EXISTS clause is a MySQL/MariaDB extension. It
prevents an error from occurring if the procedure or function does not exist. A
NOTE is produced that can be viewed with
While this statement takes effect immediatly, threads which are executing a procedure can continue execution.