Post reply

check for existence of table in tempdb

  • April 20, 2006 at 10:05 am

    #171295

    How does one check for the existence of a named table in the tempdb. Using 'exists' or ' not exists' appears to only work if the table DOES exist. When the table does NOT exist it appears that Analyzer/T-Sql simply issues an error message and then quits. In my script I am setting up a temptable to carry info forward to subscripts. I need to verify that the temptable does not exist at the outset.

    Thanks for your help..

    As you can probably tell, I am somewhat of a NEWBIE with SQL Server and am stuck with using SQL Server 2000 for now. Our current main production DB is Oracle.......(still)

     

  • April 20, 2006 at 12:05 pm

    #633339

      IF object_id('tempDB..#test') IS NOT NULL  

        drop table #test

  • April 20, 2006 at 12:48 pm

    #633358

    Thank you Pam! I've found another way, but yours appears to be much easier!

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

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