May I use the query analyzer to enter select * into # temp1 from (select ...)

wiwiclcl

In the above statement, when I run it again, I will be prompted that the table # temp1 already exists in the database. How can I delete this temporary table?
thanks

fanfan1980

drop table # temp1

fanfan1980

if (select object_id ('tempdb .. # temp1')) is not null
drop table # temp1

fanfan1980

-Wrong, change

if (object_id ('tempdb .. # temp1') is not null)
drop table # temp1

hiqwolfzzh

drop table # temp1
select * into # temp1 from (select ...)

Just select all of them every time

四不像君

# temp1 The table will not be deleted by itself until the end of the program process.