Shadow copy using Sql. Write a query to create a clone of existing table without using Create Command.

Answer 1

Try this...

SELECT *
INTO NewTableName
FROM CurrentTableName

Answer 2

I am frequently using below query..

select * into new table from old table.