Thanks :)
This solved my question. I did COMMIT after drop index and it works :)

But because into production database I do all changes with scripts, I
have a new question: how to put COMMIT into SQL script between commands?


Alexandre Benson Smith wrote:

>Raigo wrote:
>
>
>
>>How to drop primary key in Firebird 1.0.3 ?
>>
>>
>>I tried
>>ALTER TABLE AMETIGR
>> drop CONSTRAINT XPKAMETIGR;
>>
>>but get message "index in use".
>>
>>What may be wrong?
>>
>>I also tried :
>>
>>drop index XPKAMETIGR;
>>
>>ALTER TABLE AMETIGR
>> drop CONSTRAINT XPKAMETIGR;
>>
>>but still get message "INDEX in use"
>>
>>Any ideas?
>>
>>
>>
>>
>Try to commit before, and make sure no other users/transactions are
>using this table.
>
>see you !
>
>
>