Copying the Structure
The structure of one table can be copied on to another table without the records being copied. To do this, along with the SELECT statement, add a WHERE clause that yields to any FALSE condition. The following instance explains this:
CREATE TABLE employee3 AS SELECT * FROM employee WHERE 1=2;
This statement create a table known as Employee3 whose structure is the similar as Employee but the records are not copied since WHERE clause evaluates to FALSE.