sqlsql-serverazuretemp-tables

Drop temp table if it exists on SQL Azure


Is there better way to drop temp table on Azure SQL?

BEGIN TRY
    DROP TABLE #customMap
END TRY
BEGIN CATCH
END CATCH

Maybe there is no need to drop temp tables on Azure SQL since tables are dropped when session is ended.

This

if (OBJECT_ID('#candidates')) is not null
begin
    drop table #candidates;
end;

or this

if (OBJECT_ID('tempdb..#candidates')) is not null
begin
    drop table #candidates;
end;

does not work.


Solution

  • In Azure SQL Database you can use DROP IF EXISTS (DIE) syntax:

    create table #temp (id int)
    
    drop table if exists #temp