When you no longer need to retrieve the information specified by a stored procedure, or the tables or columns it references have been deleted from your database, you can delete the stored procedure.
To delete a stored procedure
The stored procedure is deleted from the database and Data View.