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
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