| Subject | Re: [firebird-support] Rename a key through write to a system table |
|---|---|
| Author | Josef Kokeš |
| Post date | 2013-07-18T06:14:08Z |
On 18.7.2013 7:08, Josef Kokeš wrote:
That solves the problem nicely.
Pepak
> Hi!Never mind, I actually *can* drop a primary key and create it again.
>
> 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
That solves the problem nicely.
Pepak