Write a query to create a new table which consists of data and structure copied from the other table.

Uday Dodiya

3.1k

Using the SELECT INTO command:

SELECT * INTO NewTable FROM EmployeeInfo WHERE 1 = 0;

Using the CREATE command :

CREATE TABLE NewTable AS SELECT * FROM EmployeeInfo;