Creating a new table, to replace an old one
925042Oct 2 2012 — edited Oct 2 2012Hello,
I need to create new table to replace an old one. Found the similar thread here, but still have a questions.
I create new table through:
create new_table as select * from old_table
I can see through DDL, that old table has two indexes and one trigger. Need I to drop an old table, indexes and trigger, rename new database to old name and then create indexes and trigger agian ?
Also I must copy/create constraints ? How to do this ?