Subject Re: [firebird-support] Trying to drop an index
Author Helen Borrie
At 02:16 PM 26/10/2005 +0200, you wrote:
>We are trying to drop an index and we get an object is in use error. We are
>certain that there are no other connections open to the database and yet we
>get this error. Is there a special trick or something?

Is this "the Royal We" or are there actually more than one of you trying to
do this?

Check for other transactions still running, involving the table that the
index belongs to, and either commit them or roll them back.

If, on the other hand, the index is a constraint index, you can't drop
it. You'll have to find the name of the constraint and drop that.