Subject Re: [firebird-support] Rename a key through write to a system table
Author Thomas Steinmaurer
>> 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

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