Write a query to create a new table which consists of data and structure copied from the other table.
Uday Dodiya
Select an image from your device to upload
Using the SELECT INTO command:
SELECT * INTO NewTable FROM EmployeeInfo WHERE 1 = 0;
Using the CREATE command :
CREATE TABLE NewTable AS SELECT * FROM EmployeeInfo;