To copy the structure of a table without copying the data, you can use the CREATE TABLE AS SELECT statement.

• Use the CREATE TABLE AS SELECT statement to create a new table with the same structure as th...read more

Create table employee_duplicate as select * from employees where 1=2;