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