Copying a table into another table is possible in SQL. You can do it using SELECT statement.
Syntax for copying a table to other table
SELECT * INTO destinationTableName FROM sourceTableName;
Example on copying a table to other table
Suppose we want to copy a table say Table1 into Table2.
So we need to write following sql query.
SELECT * INTO Table2 FROM Table1;
The above query will copy entire table Table1 into Table2.
There are lot more things that we can do with SELECT statement in sql. We will learn all in SELECT section of this tutorial.