Hello everyone:

If I excute the following: 

CREATE table Test_backup as
SELECT * FROM Test_Scores;

it creates my table without the original table's constraints or
triggers. 

Is there a way to preserve them in the copy? 

Thanks. 

Bob Powell
Database Administrator

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to