Hi to all,
i use FireBird 1.0, i need to DROP some constraints from some
different table.
I tried using a script like this:

ALTER TABLE table1 DROP CONTRAINT table1_FK2;
ALTER TABLE table2 DROP CONTRAINT table2_FK4;
ALTER TABLE table3 DROP CONTRAINT table3_FK3;
ALTER TABLE table4 DROP CONTRAINT table4_FK2;
ALTER TABLE table5 DROP CONTRAINT table5_FK6;

etc...

but after one or two successfull drop i see this error:

ISC ERROR CODE: 335544351
Unsuccessful metadata update
object INDEX is in USE

The sequence of instruction are correct (i think) in fact if:

1) i split the sequence in single instruction (one for every drop)
2) using IBConsole i open my DB
3) i run the first DROP command
4) close the connection to my DB
5) i re-open the connection
6) run the second DROP command
7) close the connection to my DB
8) i re-open the connection
9) run the third DROP command
10) .... etc ...

all work fine and i can drop all my constraints without any error.

Some suggestion ?

Best regards,
Enrico Raviglione.