Bob Powell wrote:
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?
Only if you create a schema dump of just the table and t
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
---(e