Subject Re: [firebird-support] Foreign key
Author Walter Neumann
Am Mittwoch, 27. August 2003 13:28 schrieb 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

Thank you Diego. Now it worked

Walter Neumann