Create a replica of a sql table
sql, sql-server
Solution
You can try this
SELECT * INTO Table_Copy
FROM Table
where 1=2
It will create a empty table with the same structure.
Problem
I need a query to create a table which is the exact replica but with different table name and without any data from the source table using a sql query!