Drop a table and views

  • ahmadharis

    SSC Veteran

    Points: 205

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

  • Robert Seliga

    SSC Journeyman

    Points: 92

    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

    Thanks for the script.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    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.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply