--- In firebird-support@yahoogroups.com, Hans Hoogstraat <hans@h...>
wrote:

> You don't happen to use something like IB_WISQL with the cursor

sitting on

> the name of the table you are trying to modify, when you use the same
> program to drop the primary key from that table ? Happened to me a

few times

> :)

Hi Hans,

I tried with IB_WISQL with the browser closed, and the native isql.

SQL> alter table fuellog drop constraint INTEG_68;
Statement failed, SQLCODE = -607

unsuccessful metadata update
-object INDEX is in use

Same thing. :(

I just tried on a copy of the database, with only my connection as the
only user and it worked fine.



Cheers,

:)