• Or

    IF OBJECT_ID('dbo.SPName', 'P') IS NOT NULL

    BEGIN

    DROP PROCEDURE [dbo].[SPName]

    END