Create table as ?

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 Received on Sun Apr 30 2000 - 00:00:00 CDT