--- In ib-support@yahoogroups.com, "mkchitrada" <mkchitrada@h...>
wrote:

> While trying to drop a foreign key relation I am getting the
> error "object INDEX is in use".
>
> Could some body tell me why?
> When will we get such problem?
>
> Thanks.

I came across this error once before because I had more than (1)
active connection to the database that I was trying to modify. I had
two different database admin tools open and everytime I attempted to
drop the foreign key I received the same error you are describing.
Make sure that you have only one connection to the database and then
try again.

I hope this helps.