First guess: create a new Index with the appropriate name and drop the old

Kjell Rilbe <kjell.rilbe@...> wrote:

>Any simple way (including update in an rdb$... table) to rename an
>index?
>
>Drop/recreate is a bit expensive on 200+ million record tables...
>
>The rename is motivated by a renamed column and my desire to keep the
>name of the index "in sync".
>
>Regards,
>Kjell
>
>--
>------------------------------
>Kjell Rilbe
>DataDIA AB
>E-post: kjell.rilbe@...
>Telefon: 08-761 06 55
>Mobil: 0733-44 24 64
>
>
>
>------------------------------------
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]