How to Quickly Create a Copy of a Table using Transact-SQL

The easiest way to create a copy of a table is to use a Transact-SQL command. Use SELECT INTO to extract all the ...

technet.microsoft.com