procedure to delete content of a table sql code example

Example: how to delete a procedure in sql

DROP PROCEDURE <stored procedure name>;  
GO