Subject | Re: [firebird-support] How to rename index without DROP / CREATE |
---|---|
Author | Helen Borrie |
Post date | 2006-01-30T11:45:42Z |
At 10:31 PM 30/01/2006, you wrote:
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
> > Firebird 1.5And question 0 would be why don't your constraint indexes already
> >
> > 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
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