drop the sp in sql code example

Example: delete stored proc sql server

DROP PROCEDURE <stored procedure name>;  
GO