> Firebird 1.5
>
> Is it possible to somehow rename an index that has been created on behalf

of

> a primary / foreign key without dropping and recreating the constraints

and

> their indices?

No.

>DROP / CREATE is no option for me as this takes far to long.
> But I need self-defined names as I have to provide my own PLAN for some
> selects.

Question 1 would be: why are you using the PLAN clause?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com