How to copy table in SQL?

We can use the SELECT INTO statement to copy data from one table to another. Either we can copy all the data or only some specific columns.

This is how we can copy all the columns into a new table:

SELECT *
INTO newtable
FROM oldtable
WHERE condition;

If we want to copy only some specific columns, we can do it this way:

SELECT column1, column2, column3, ...
INTO newtable 
FROM oldtable
WHERE condition;