Create a Quick Copy of a Table and Place it in the Same Database

Sometimes you need a situation to quickly create a copy of an existing table in MSSQL Server. For example, you have a table named Person and you need to copy it to a table named Person_1 in the same database. To do this, you need to use the SELECT INTO construct:

SELECT *
INTO dbo.Person_1
FROM dbo.Person;

Quick MS SQL Table Copy

This solution allows you to quickly copy the table. But you need to be careful because, with this method, columns and data are copied. But entities such as the index will not be copied(in our case it is the Primary Key).

Leave a Comment