Which command is used to delete a procedure from the memory?

• Manually
• By SQL Command

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.