ugly1

 Profile Answers by ugly1 

• Jan 25th, 2008

 

below shown query will copy table with constraints and data into new table. here table_copy is the new table and old_table is the table whose data and constraints are to be copied.

create table table_copy as (select * from old_table)

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 21st, 2008

 

Using the following query you may copy table structure and data but you can't copy constraints.

Create table emp_copy as select * from emp;