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;

 
Next Topic: SQL RENAME Table with example.
Previous Topic: SQL ALTER Table with example.