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~