temp table

• swush

  SSC Rookie

  Points: 41

  More actions

  June 26, 2002 at 5:30 am

  #101176

  Hi,

  i want to check for the existience of a temporary table because i need to drop it in that case.

  i tried

  use tempdb

  Select name From sysobjects Where name = 'tablename'

  but it won't work because the table name is followed by underscores, like '#test________ ...' .

  so is there another way to do this as i don't want to build a workaround for the name?

  greetings

  jan

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  June 26, 2002 at 5:45 am

  #431652

  Hi,

  if (select object_id('tempdb.dbo.#test'))

  is not null

  print 'test'