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.
In Azure SQL Database you can use DROP IF EXISTS (DIE) syntax:
create table #temp (id int)
drop table if exists #temp