Once you create a procedure, it remains in the database until someone explicitly removes it. Only the owner of the procedure or a user with the DROP ANY PROCEDURE system privilege can drop the procedure from the database.
Execute a DROP PROCEDURE statement to drop the procedure from the database.