Re: [GENERAL] Create AS question

2004-12-10 Thread Joshua D. Drake
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

[GENERAL] Create AS question

2004-12-10 Thread Bob Powell
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