Use SELECT INTO To Copy Data Between Tables

You can use the SELECT INTO statement finds data and then copies that data between tables or databases. To do so, use the following syntax:

SELECT *
INTO newtablename
FROM tablename;

So to copy that Customers table to a new table called Customers2:

SELECT *
INTO Customers2
FROM Customers;

Or to copy only certain columns into Customers2, we’d use the following:

SELECT ID,Site
INTO Customers2
FROM Customers;