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.