SQL COPY Table

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;