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
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
May 10, 2016 at 7:01 am
#1877760
Thanks for the script.
#1877761
Robert Seliga (7/23/2008)save yerself some typing:if object_id('dbo.table_name') is not null drop dbo.table_nametoss that at the top of the script too before dropping the sp ahead of the create statement
Robert Seliga (7/23/2008)
Thanks for that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply