Tmp Tables

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 1

The following will work for you;

if exists

(

select name from tempdb..sysobjects where name like '#YourTable%'

)

drop table #YourTable

Hope this helps.

David

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Steve Johnson Default port Points: 1404 More actions · Answer 2

Thanks David that will work great!!!

Steve Johnson

sergey Old Hand Points: 325 More actions · Answer 3

There's an easier statement:

if not OBJECT_ID('#TableName') is Null

and so on.