Hi,

I'm not sure if this has been already discussed..

Renaming a database table doesn't change automatically created index
names, so that if you do

create table t(a int primary key);
alter table t rename to t1;
create table t(a int primary key);

then the second create will fail. Would it be possible to have the
alter table command to also rename the index? The same goes for
columns with unique.

ciao
Andreas

13 Sep 2000 10:59:30 +0200
Andreas Degert <ad@papyrus-gmbh.de>
alter table rename to ..