Pitfalls of renaming tables in sql server
Another option is to use partition switching once you have both tables set up create a switch out table.

Then do a simple switch command like this:

ALTER TABLE [Table Name] SWITCH
   TO [Table Name]_SwitchOut

ALTER TABLE [Table Name]_SwitchIn SWITCH
   TO [Table Name];


Then simply drop the in and out tables.