Copy Table in SQL

The SELECT INTO statement is used to copy a table data into another table.

Syntax:

Select * into destinationTable from sourceTable;

Example:

Select * into EMPLOYEE1 from EMPLOYEE;