This statement removes one or more stored procedures from the current database.
Syntax
DROP PROCEDURE [ IF EXISTS ] procedure-name
Remarks
The expression IF EXISTS causes the statement to return success instead of an error if a procedure does not exist. IF EXISTS does not suppress other errors.
Examples
The following statement drops the stored procedure myproc from the dictionary: