Copy MS SQL table with Data

It is always a necessity to keep original table structure an data before modifying the table structure. Easiest way is to copy the table into another table and keep the backup, which can be restored when required.

To copy MS SQL table with data use following SQL command

SELECT * INTO newtable FROM oldtable