SQL Server copy all rows from one table into another i.e duplicate table

Question

I want to keep a table as history and replace it with an empty one. How can I do this through Management Studio?

Answer 1

Duplicate your table into a table to be archived:

SELECT * INTO ArchiveTable FROM MyTable 

Delete all entries in your table:

DELETE * FROM MyTable 

Answer 2

Don't have sql server around to test but I think it's just:

insert into newtable select * from oldtable;