How to create a table structure without copying data from a database table?

Question

I was asked in viva "how to create a table structure without copying data from a database table?" I was sure of my answer. My answer is: `

CREATE TABLE new_table AS (SELECT *FROM old_table);

Was I right or wrong?

+3

user3355518 Feb 26 '14 at 13:29

3 answers

dcp · Answer 1 · 2014-02-26T13:33:51+0000

CREATE TABLE new_table AS (SELECT * FROM old_table where 0=1);

mahbub_siddique · Answer 2 · 2014-02-26T16:37:34+0000

No. Your answer is incorrect. You can use this SQL query.

CREATE TABLE *new_table* AS (SELECT *FROM *old_table* WHERE *statement=false*);

The following is an example:

CREATE TABLE *new_table* AS (SELECT *FROM *old_table* WHERE *1=2*);

I think this will serve your purpose ...: P

simbu · Answer 3 · 2014-02-26T13:41:33+0000

CREATE TABLE new_table AS SELECT * FROM old_table where 0=1;

where where , , 1 = 2,2 = 3..cc., , "where" false, old_table.