There are two ways to delete a procedure from memory/database.
1. Manually
To delete a stored procedure manually fallow the below steps.
Open your SQL Server and navigate procedure section on the left side which is below the table section
Expend procedure section, you will see your stored procedure in that section if it is not there refresh the section, now you will be able to see the procedure.
Right-click on procedure name and select drop option and click ok. It will delete your procedure.
1. By SQL Command
This is the simplest way to deleting a stored procedure, just run below two commands in the given sequence it will delete the procedure.
command 1
use database_name
Command 2
drop procedure procedure_name
Note: in the above commands database_name is the name of the database in which stored procedure is created and procedure_name is the name of your procedure which you want to delete.