Check if temp table exists

• Priya004

  Ten Centuries

  Points: 1368

  More actions

  August 20, 2014 at 5:40 am

  #290046

  This code is not working

  IF OBJECT_ID('test.dbo.#temphistory') is not null

  begin

  drop table #temphistory

  end

  go

• er.mayankshukla

  SSCarpal Tunnel

  Points: 4190

  More actions

  August 20, 2014 at 5:46 am

  #1739533

  IF OBJECT_ID('tempdb..#temphistory') IS NOT NULL

  DROP TABLE #temphistory

• er.mayankshukla

  SSCarpal Tunnel

  Points: 4190

  More actions

  August 20, 2014 at 5:47 am

  #1739534

  Temp tables go to tempdb not any other database

• Priya004

  Ten Centuries

  Points: 1368

  More actions

  August 20, 2014 at 7:01 am

  #1739557

  OH ..ok thanks..