Subject Re: [firebird-support] Rename a key through write to a system table
Author Josef KokeŇ°
On 18.7.2013 7:08, Josef KokeŇ° wrote:
> Hi!
> 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.