Hi Walter,

> creaiting a foreigen key, there is created an index and a constraint. If I
> want to delete the index, it is not possible - it is used form the
> constroint. If I try to delete the constraint, it is not possible too - it

is

> used from the index. How can I stop this.
> Thank you for your advice.

You can drop the constraint - but the index will be droppes as well.

What is your problem? "index in use"?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com