Subject Re: [firebird-support] Foreign key
Author Diego - DM2
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

----- Original Message -----
From: "Walter Neumann" <walter@...>
To: <>
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
> 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:
> Your use of Yahoo! Groups is subject to