Subject Re: [firebird-support] How to rename index without DROP / CREATE
Author Helen Borrie
At 10:31 PM 30/01/2006, you wrote:


> > Firebird 1.5
> >
> > Is it possible to somehow rename an index that has been created on behalf
>of
> > a primary / foreign key without dropping and recreating the constraints
>and
> > their indices?
>
>No.
>
> >DROP / CREATE is no option for me as this takes far to long.
> > But I need self-defined names as I have to provide my own PLAN for some
> > selects.
>
>Question 1 would be: why are you using the PLAN clause?
>
>Martijn Tonies

And question 0 would be why don't your constraint indexes already
have user-defined names? Well, don't bother to answer that....but
there's no reason why you have to put up with system-defined names
for either you key constraints or their indexes.

./hb