Checking if An object Exists

• Anthony Malone

  Mr or Mrs. 500

  Points: 538

  More actions

  May 29, 2003 at 9:55 am

  #101502

  How do I Check initally if a Object exists. The reason Being I need to Drop an exsisting table before i Recreate the Table With a Select Into Query. If The Table Does not exist i want the Select into Statement to Execute but if the Table exsists i want to drop the Table before i recreate the table with the Select into Statement. I Hope this question Makes Sense.

  Anthony Malone

  
  Anthony Malone

• luanjubica

  SSC-Addicted

  Points: 408

  More actions

  May 29, 2003 at 9:59 am

  #459047

  if exists (select 1

  from sysobjects

  where id = object_id('yourtable')

  and type = 'U')

  select into .........

  else

  drop table yourtable

  Luani

  
  Luani

• tkbr0wn

  Ten Centuries

  Points: 1092

  More actions

  May 29, 2003 at 10:33 am

  #459062

  That is kinda backwards. I always use

  IF COALESCE(objectproperty(object_id('TEST_TABLE'),'IsTable'),0) = 1

  begin

  drop table TEST_TABLE

  end

  Much faster and simpler than hitting sysobjects