Drop Snippets

Drop Stored Procedure

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[rsp_proc or usp_proc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[rsp_proc or usp_proc];

Drop Table

IF OBJECT_ID('[dbo].[sourcetable]') IS NOT NULL
DROP TABLE [dbo].[sourcetable];

IF OBJECT_ID('tempdb..#temptable') IS NOT NULL
DROP TABLE #temptable;