SQL: Check For Temp Table and Drop Temp Table If It Exists

Check to see if a temp table exists. If so, drop it.

copy

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