Copy Structure of a Table

Posted on July 16, 2008 by pandazen

Usually, when we want to copy table, we use this command:

CREATE TABLE bck_customer AS
SELECT * FROM customers;

But I intended to copy a table, only copy the structure without data that already in the table.
So i have to modify that sql to do that, then the command:

CREATE TABLE bck_customer AS
SELECT * FROM customers
WHERE 1 = 2;

Filed under: Oracle | Tagged: , , | 2 Comments »