Drop Stored Procedure Syntax:
DROP PROCEDURE stored_procedure_name
Drop Stored Procedure Example:
DROP PROCEDURE SalesByCustomer
GO
DROP PROCEDURE stored_procedure_name
DROP PROCEDURE SalesByCustomer
GO