Post reply

Temp Table Exist

  • June 18, 2002 at 3:33 pm

    #158578

    What's the best way to check to see if a temp table exist?

  • June 18, 2002 at 4:44 pm

    #431099

    if exists (select *

    from tempdb.dbo.sysobjects

    where id = object_id(N'tempdb..#temptbl'))

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

    Edited by - antares686 on 06/18/2002 4:44:54 PM

  • June 19, 2002 at 4:43 am

    #431118

    That does it, thank you very much for the help.

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

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