create table table_name as ( select * from old

How can I create a table from another table without copying
any values from the old table?

Question Posted / anji

8 Answers
12853 Views
I also Faced
E-Mail Answers

Answer Posted / anji

create table table_name as ( select * from old_table where 1=2)

from this query we can create a new table structure from old
table structure with out data

Is This Answer Correct ?

26 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is embedded sql in db2?

953

How do you write a subquery?

961

Which query operators in sql is used for pattern matching?

901

What trigger means?

926

What is the reports view in oracle sql developer?

924

Is left join same as join?

936

What is exit statement?

955

How do I trace sql profiler?

919

how to do backup entire database? : Transact sql

1066

What are the subsets of sql?

1033

How can we store rows in PL/SQL using array?

1158

What is a rank in sql?

897

When do we use triggers?

1025

What is sql lookup?

864

What are the different type of joins in sql?

905