Deletion of SQL Server temporary tables

1, the wrong delete operation:

--Bad temporary table delete operation because the database is different

IF EXISTS (SELECT * from sysobjects WHERE object_id = object_id (N ' [dbo].[ #tempTable] ') and type in (N ' U '))

Begin

DROP TABLE [dbo]. [TempTable]

End

--incorrect temporary table deletion because the temporary table name has changed

if exists (SELECT * from tempdb.dbo.sysobjects where id = object_id (N ' [#temptable] '))

Begin

drop table #temptable

End

2, the correct way to delete:

--The correct temporary table delete operation

If object_id (' tempdb#temptable ') is not null Begin

drop table #tempTable

End