Thank you Thomas

Just getting out of the application solve the problem.

Greetings.

Walter.

On Tue, Jul 12, 2011 at 2:42 PM, Thomas Steinmaurer <ts@...>wrote:

> **
>
>
> > 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!
>
>
>


[Non-text portions of this message have been removed]