How to check if a temporary table exists and delete it if it does before creating a temporary table?

#mssqlserver #tsql

You can check if the previously created temporary table exists before creating the same table again in your stored procedure. Drop them if they exist.

Code:

// checks that the temporary table 'results' exists in the SQL tempdb.
IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO

Top comments (1)

Bruno Dantas • Feb 6 • Edited

Another way is

DROP TABLE IF EXISTS #YOUR_TEMP_TABLE

Why Current AI Text Style Transfer Metrics Fall Short - New Study Shows Major Flaws in Automated Evaluation Methods

Mike Young - Feb 26

Study Shows Top AI Models Fail at Basic Pattern Recognition Tasks

Mike Young - Feb 26

AI Creates Truthful Marketing Content with 91% Accuracy, Boosting Persuasion by 23%

Mike Young - Feb 26

AI Creates Ultra-Realistic Rain in Photos Using Graphics Rendering and Neural Networks

Mike Young - Feb 26

DEV Community

How to check if a temporary table exists and delete it if it does before creating a temporary table?

Top comments (1)

A Workflow Copilot. Tailored to You.

Read next

Why Current AI Text Style Transfer Metrics Fall Short - New Study Shows Major Flaws in Automated Evaluation Methods

Study Shows Top AI Models Fail at Basic Pattern Recognition Tasks

AI Creates Truthful Marketing Content with 91% Accuracy, Boosting Persuasion by 23%

AI Creates Ultra-Realistic Rain in Photos Using Graphics Rendering and Neural Networks

Okay