332 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.
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