To drop a Stored Procedure syntax as follows:
DROP PROCEDURE | PROC _spName;
A basic Stored Procedure drop example:
USE Pubs
GO
//Create a SP///
CREATE PROCEDURE SP_getaColumnData
AS
SELECT fname FROM employee;
//drop SP///
DROP PROCEDURE SP_getaColumnData
The command(s) completed successfully.