---With date from existing table to new table. SQL> create table new

How to copy a table in another table with datas?

Question Posted / raghunanda

9 Answers
14188 Views
I also Faced
E-Mail Answers

Answer Posted / raghunanda

---With date from existing table to new table.
SQL> create table new_table_name as select * from old_table_name where 1=1;
---without data
SQL> create table new_table_name as select * from old_table_name where 1=2;

Thanks,

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why we use cross join?

937

What is write ahead logging in sql server?

1028

How many tables can you join in sql?

942

How you improve the performance of sql*loader? : aql loader

996

tell me about various levels of constraint. : Sql dba

1025

Which is the correct statement about truncate and delete?

1089

what are different types of collation sensitivity? : Sql dba

1057

Enlist the characteristics of pl/sql?

1778

What is sql analyzer?

995

Explain the uses of control file.

1024

What is meant by cursor in sql?

972

What is sql architecture?

1031

how to install mysql? : Sql dba

1090

How do you create a unique index?

1031

what is index? : Sql dba

988