tSQL: Drop Temp Table if Exists

This article describes how to check if a temporary table exists before you delete it.

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