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