Re: Create table as ?

You'll have to create the constraints and indexes manually. There is no magical command that says CREATE TABLE AS SELECT * FROM TEST INCLUDING CONSTRAINTS AND INDEXES; HTH,
Brian

Mujahid Hamid wrote:
>
> Hello All,
>
> When I use create table as select * from test, then I loose all the RI
> constraint in the new table, is there a way where I use create table as and
> bring all the constraints in the original table to the new table ?
>
> With Thanks
>
> Mujahid
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================