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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With