Why can't you drop the constraint?
I f you create a constraint like this:
alter table xxx add constraint "nameOfTheForeignKey" foreign
key(nameOfTheFieldOf xxx) references yyy(nameOfTheFieldOf yyy)

it'll indeed create an index, like RDB$FOREIGN37, for example, but if you do

alter table xxx drop constraint "nameOfTheForeignKey" the Fb will itself
drop the index for you!

Diego Menin
DBA - DM2/Brasil
www.cartonline.com.br

----- Original Message -----
From: "Walter Neumann" <walter@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, August 27, 2003 6:46 AM
Subject: [firebird-support] Foreign key


> Hallo,
> 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.
>
> Walter Neumann
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>