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
> www.cartonline.com.br

Thank you Diego. Now it worked

Walter Neumann