Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[HACKERS] alter table rename to ..

0 views
Skip to first unread message

Andreas Degert

unread,
Sep 13, 2000, 5:02:24 AM9/13/00
to
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

0 new messages