Copy of one Table Data to Another Table in MS SQL

By AMIT S VAISHNAV
main Image
In MS SQL for copying table data from old table to new table.

You have to use the following query mentioned below

SELECT * INTO newtablename FROM oldtablename

But for copying only the structure of old table to new table without data in it.
Then you have to use the following query

SELECT * INTO newtablename FROM oldtablename WHERE 1=2


I hope this article will help you.