IT:AD:SQL Server:HowTo:Clone A Table

The easiest way to create a copy of a table is to use a Transact-SQL command. Use SELECT INTO to extract all the rows from an existing table into the new table. The new table must not exist already:

SELECT * INTO CurrCustomers FROM Customers