Drop a stored procedure
You can remove a stored procedure by using the DROP PROCEDURE command.
For example, to drop the customer procedure, use a command similar
to the following example:
DROP PROCEDURE customer();
DROP PROCEDURE