Home Forums Article Discussions Article Discussions by Author Discuss content posted by Haris Ahmad Drop a table and views RE: Drop a table and views
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_nametoss that at the top of the script too before dropping the sp ahead of the create statement
Robert Seliga (7/23/2008)
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.