SQL Server Drop temp table if it exists on SQL Azure

xpcnnkqh 于 2023-10-15 发布在其他

关注(0)|答案(2)|浏览(86)

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.

2条答案

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

create table #temp (id int)

drop table if exists #temp

IF OBJECT_ID('tempDB..#myTempName','U') IS NOT NULL
   drop table #myTempName

temporary tables are created in tempDB , not whatever DB you're currently using as the default db.