Subject | I cannot drop a primary key |
---|---|
Author | W O |
Post date | 2011-07-12T17:18:40Z |
Hello everybody
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?
Greetings.
Walter.
[Non-text portions of this message have been removed]
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?
Greetings.
Walter.
[Non-text portions of this message have been removed]