How to Check for and Delete Temp Local Table?

• johna1

  Ten Centuries

  Points: 1184

  More actions

  December 23, 2003 at 10:46 am

  #107127

  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LV_Group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  drop table [dbo].[LV_Group]

  The above syntax checks and deletes a regular table. How do I write one that checks for a local temp table? For example, how do I check for the existence of a local temp table "#tbl_temp" and delete it? Thanks.

• jxflagg

  Hall of Fame

  Points: 3817

  More actions

  December 23, 2003 at 11:11 am

  #487651

  if exists (select * from tempdb.dbo.sysobjects where id = OBJECT_ID('tempdb..#tbl_temp'))

  drop table [dbo].[#tbl_temp]

• Clay_G

  Default port

  Points: 1454

  More actions

  December 23, 2003 at 5:43 pm

  #487697

  or just

  Object_ID('TempDb..#Temp') is not NULL

  (which I found in a previous posting but I cannot find now to attribute it, sorry)