Thread: alter table rename to ..

alter table rename to ..

From
Andreas Degert
Date:
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