> I have a table called BANKS, it has not rows now.
>
> I want to change its primary key, but writing:
> ALTER TABLE BANKS DROP CONSTRAINT INTEG_4;
>
> shows me the following error message:
> Unsuccessful metadata update.
> Object INDEX is in use.
> SQL Code: -607
> IB Error Number: 335544351
>
> What's the problem?
>
> There are not objects that depends on BANKS.
>
> How can I drop the primary key?

A transaction/statement has the table/index in use, thus the error
message. Check out the MON$ tables for identifying the offending statement.

Usually when working with indexes DDL wise, you need exclusive access to
the object in question.

--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!