how to drop procedure in sql code example

Example: how to delete a procedure in sql

DROP PROCEDURE <stored procedure name>;  
GO