Quickly Create a Copy of a Table using Transact-SQL

SELECT * INTO [some new table name] FROM [table to be copied]


Reference 

Share Article : Quickly Create a Copy of a Table using Transact-SQL

Quickly Create a Copy of a Table using Transact-SQL