All Forums Database
MattW At ATT 11 posts Joined 06/06
22 Aug 2006
How do I make an exact copy of a current table

Any Ideas?

Can I just
Create Table 1 as
(Select * from Table 2)

dnoeth 684 posts Joined 11/04
22 Aug 2006

Definition plus data?
create table newtab as oldtab with data;

Or just the definition?
...with no data;

check the manuals for details...

Dieter

GreatSushant 12 posts Joined 05/05
22 Aug 2006

You can also try out this

Create table a as
;
Which will be the exact replica of your old table.

GreatSushant 12 posts Joined 05/05
22 Aug 2006

Sorry

rewritting the syntax

Create table a as old_table_name

sushant

GreatSushant 12 posts Joined 05/05
23 Aug 2006

The exact syntax is as below:
create table product_1 as product with data;

You must sign in to leave a comment.