Using T-SQL to check whether a global temp table exists

• Venkataraman-408293

  SSChasing Mays

  Points: 650

  More actions

  November 30, 2007 at 10:03 am

  #377274

  Hi

  How to check using T-SQL whether a global temp table exists ?

  Any one help me ????

  :):):)

  thanks

  venkat

• Venkataraman-408293

  SSChasing Mays

  Points: 650

  More actions

  November 30, 2007 at 10:14 am

  #756051

  I got it...

  DECLARE @temp_table VARCHAR(100)

  SET @temp_table = '##my_temp_table'

  IF NOT EXISTS (SELECT 'x'

  FROM tempdb..sysobjects

  WHERE type = 'U' and NAME = @temp_table)

  PRINT 'temp table ' + @temp_table + ' does not exist'

  ELSE

  PRINT 'temp table ' + @temp_table + ' exists.'

  thanks

• Jeff Moden

  SSC Guru

  Points: 1004593

  More actions

  November 30, 2007 at 11:55 am

  #756093

  IF OBJECT_ID('TempDB..##my_temp_table','U') IS NOT NULL

  PRINT 'Table Exists'

  ELSE

  PRINT 'Table does not Exist'

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)