how to drop a stored procedure in sql server

 666 Total Views,  1 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.

use YourDatabaseName
DROP PROCEDURE schema_name.procedure_name
use banking_db
drop procedure dbo.wsp_Get_CustomerName
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

2 thoughts on “how to drop a stored procedure in sql server”

  1. Sir , insert value in identitity column & ALTER PROCEDURE
    It would have been better for me to discuss it once again.

Leave a Reply

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