drop temp table if exists code example
Example 1: sql server drop temp table if exists
IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO
Example 2: drop table if exists
DROP TABLE IF EXISTS dbo.Scores
Example 3: Check if a temporary table exists and delete if it exists
DROP TABLE IF EXISTS #lu_sensor_name_19
CREATE TABLE #lu_sensor_name_19...
Example 4: Check if a temporary table exists and delete if it exists
IF OBJECT_ID('tempdb..#lu_sensor_name_19') IS NOT NULL
BEGIN
DROP TABLE #lu_sensor_name_19
END
CREATE TABLE #lu_sensor_name_19...