To check if the procedure already exists and drop

 

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'ProcedureName') 

DROP PROCEDURE ProcedureName

GO