how to drop a temporary table

[sonysunny]

hai,

I want to drop a temporary table if it exists. How can we do this.


thanks in advance.

[amitpatel66]

hai,

I want to drop a temporary table if it exists. How can we do this.


thanks in advance.

please post what you have tried so far?

[nedu]

Hi,

You shall use the below code . .

if exists (select * from dbo.sysobjects where id = object_id(N'tempdb..#temp1') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin
drop table [#temp1]
print 'dropped'
End
Else
Begin
print 'No Such tables'
End

Regards,
Nedu. M