some duh help please

• ghughes

  SSCrazy

  Points: 2201

  More actions

  April 6, 2004 at 7:24 am

  #107479

  I have done some searching in the BOL looking for a way to check the existence of a table in TEMPDB.  No luck.

  I am looking to check the existence a table in the TEMPDB.  The table is called #TEMP_WORK.  I want to check if it is there before using a create table statement.

  I am running short of time, and don’t have my SQL books with me.  Can some help me out?

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 6, 2004 at 7:52 am

  #501870

  if not exists(select object_id('tempdb..#temp_work'))

    print 'create temp table'

  else

    print 'exists'

• ghughes

  SSCrazy

  Points: 2201

  More actions

  April 6, 2004 at 8:29 am

  #501878

  thank you for your help.  I just could not remember syntax for this.  Daylight saving time is taking its toll on me this morning