Code: Select all
IF OBJECT_ID('tempdb..#TempTableName') IS NOT NULL
DROP TABLE #TempTableName
How to check if a temp table exists and delete it in SQL Server
How to check if a temp table exists and delete it in SQL Server
To check if a temp or hash table exists in SQL Server, and if it does then delete or drop it:
If you find Z12 Web Tools useful and would like to show your appreciation...
Why not Buy Me A Coffee to say: Thank You!
Why not Buy Me A Coffee to say: Thank You!