how to drop a stored procedure in sql server

 225 Total Views,  2 views today

You are no longer using a stored procedure and want to drop it from database.
Drop stored procedure from database using DROP PROCEDURE command.

Syntax:
use YourDatabaseName
go
DROP PROCEDURE schema_name.procedure_name
GO

Example:
use banking_db
go
drop procedure dbo.wsp_Get_CustomerName
go

Note:
Once a stored procedure is dropped its definition is removed from the database's system tables.
Code references to the stored procedure by other procedure or triggers will fail upon execution
once the stored procedure has been dropped.

Also See: how to drop a store procedure if exists in sql server