>> I realize that the official answer to "can I rename an index" is "no",
>> and that directly writing to the system tables is generally a poor idea.
>> But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in
>> RDB$INDICES and RDB$INDEX_SEGMENTS? I have this itch I would like to
>> scratch, where I created a primary key of a table with a bad name...
>>
>> The target Firebird versions are 2.1 and 2.5.
>>
>> Thanks,
>>
>> Pepak
>
> Never mind, I actually *can* drop a primary key and create it again.
> That solves the problem nicely.

Right, as long as no FK constraint references the primary key fields in
question. You then would first need to drop the FK constraint(s).


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.