Scaz is a place dedicated to providing the content, skills, tools and services you need to learn and succeed in making money online.

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;