How to drop ##temp_tbl?

[19511950]

How to drop global ##temp_tbl if exist, but if not don't drop.

When I try to run sp second time it says:
There is already an object named '##temp_tbl' in the database.

If I add into sp drop table '##temp_tbl' and try to run in a while it says:

Cannot drop the table '##temp_tbl', because it does not exist in the system catalog.

I need to have global ##temp_tbl not local #temp_tbl

Please help.

 

[rajeevnandanmishra]

Hi

Try this,
-----
if exists(select * from tempdb..sysobjects where name = '##temp_tbl')
drop table ##temp_tbl
-----




---
Raj

 

[sunila7]

Hi,

Try this TSQL

if not exists
(select * from [tempdb].[dbo].[sysobjects]
where id = object_id('[tempdb].[dbo].[##temp_tbl]'))
Drop table ##temp_tbl

Sunil

 

[19511950]

Thanks a lot Raj.
It works.

Mark