Hi to all,
i use FireBird 1.0, i need to DROP some constraints from some
different table 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


I have verified the validity of sequence and i run the script as
SYSDBA.

Curiosity: if i do the same sequence of instruction but after every
instruction i make a Disconnect all work well and i can drop all my
constraints without any error.

I try also to add a COMMIT after any ALTER TABLE but the result are
the same.

Some suggestion ?

Best regards,
Enrico Raviglione.