I want to copy a table as another table. Like copying a document in windows.
Is it possible?
I have a scenario where I need to create 5 tables similar to existing table. The only change is table name and adding some prefix text to existing columns.
Is there any simple way we can do this?
asked Dec 15 '09 at 03:11 PM in Default
Check out the 'CREATE TABLE AS SELECT' syntax. You can build a table based on the results of a SELECT statement.
answered Dec 15 '09 at 03:31 PM