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

Leave a Reply

Your email address will not be published. Required fields are marked *