Copy the structure of a table without copying the data in SQL

In Oracle:

CREATE TABLE TABLE_X
AS
SELECT * FROM table_y WHERE 1=0;

Thanks,
Shankar

There's a little hack you can use to easily do this:

SELECT * INTO newTable  FROM oldTable WHERE 0 = 1

As the WHERE clause always returns false, no records are copied just the structure : )

SELECT TOP 0 * INTO newtable FROM oldtable

SELECT TOP 0 * INTO employee1  FROM employee