---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
14482 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

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1008

what is subquery? : Sql dba

1187

What is acid property in a database?

1084

How many sql core licenses do I need?

994

What is procedure explain with program?

1063

What are stuff and replace function?

1141

Can we use view in stored procedure?

953

How does index help in query performance?

1087

What is varchar example?

1080

What are the types of join in sql?

1146

What is a trigger in sql?

1232

What is synchronized subquery?

1216

Is it possible to create startup or shutdown trigger for on-schema?

1089

How to select 10 records from a table?

1204

Is a secondary key the same as a foreign key?

1113