remove a procedure from database code example

Example: delete stored proc sql server

DROP PROCEDURE <stored procedure name>;  
GO