SQL Server checks whether a temporary table exists

If object_id ('tempdb .. # temptable1 ') is not null drop table # The above Type of temptable1 is not checked. # temptable1 may be the name of view or procedure, the complete check is as follows: if exists (select * From tempdb. DBO. sysobjects where id = object_id (n' tempdb .. # temptable1 ') and type = 'U') Drop table # temptable1