Drop a table and views

• ahmadharis

  SSC Veteran

  Points: 205

  More actions

  June 5, 2008 at 12:25 pm

  #192011

  Comments posted to this topic are about the item Drop a table and views

• Robert Seliga

  SSC Journeyman

  Points: 92

  More actions

  July 23, 2008 at 7:03 am

  #847001

  save yerself some typing:

  if object_id('dbo.table_name') is not null

  drop dbo.table_name

  toss that at the top of the script too before dropping the sp ahead of the create statement

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 10, 2016 at 7:01 am

  #1877760

  Thanks for the script.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 10, 2016 at 7:01 am

  #1877761

  Robert Seliga (7/23/2008)

  ---

  save yerself some typing:

  if object_id('dbo.table_name') is not null

  drop dbo.table_name

  toss that at the top of the script too before dropping the sp ahead of the create statement

  Thanks for that.