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

Question

I was asked in a viva "how can you create a table structure without copying data from a database table?" I was quite sure with my answer. My answer was:`

CREATE TABLE new_table AS (SELECT *FROM old_table);

Was I right or wrong?

Answer 1

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

Answer 2

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

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

Like this an example is following:

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

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