sql server drop stored procedure using * code example

Example: delete stored proc sql server

DROP PROCEDURE <stored procedure name>;  
GO