To drop a stored routine, use the DROP PROCEDURE or DROP FUNCTION statement. DROP PROCEDURE [IF EXISTS] proc_name DROP FUNCTION [IF EXISTS] func_name It is an error if the named routine does not exist. Include the IF EXISTS clause to generate a warning instead. (The warning can be displayed with SHOW WARNINGS.) IF EXISTS is a MySQL extension to standard SQL. |