Subject Re: Modify Primary key
Author skotaylor
--- In, Hans Hoogstraat <hans@h...>
> 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.