Dropping stored procedures
Use the DROP statement to drop all versions of a stored procedure and its associated packages at the current server.
About this task
You might want to drop a stored procedure for a number of reasons. You might not use a particular stored procedure any longer, or you might want to migrate an external SQL procedure to a native SQL procedure, because native SQL procedures typically perform better and have more functionality than external SQL procedures.
Procedure
To drop a stored procedure:
Issue the DROP PROCEDURE statement, and specify the name
of the stored procedure that you want to drop.
Example
For example, to drop the stored procedure MYPROC in schema SYSPROC, issue the following statement:
DROP PROCEDURE SYSPROC.MYPROC;