I have one table named temp and another table which I have added a few fields to - let's call it temp_test. It has all the same fields as table temp except it also has a birthdate field just recently added. Table temp has many indexes and sequences created to handle certain fields and what not. What I would like to know is simply if I insert into temp_test select * from temp and then drop table temp and create table temp as select * from temp_test, will I lose the indexes and sequences attributed to the original table temp? thanks for any help on this one. M~
