Hello,
Using FB1 I have a script to reorganize my DB with DDL-Statements
like this:
ALTER TABLE ARTIKEL DROP CONSTRAINT FK_ARTIKEL_U_MWST;
commit;
ALTER TABLE ARTIKEL DROP CONSTRAINT FK_ARTIKEL_V_MWST;
commit;

The error "index is in use" comes at the second alter table. What
does it mean? Thank You
Dieter Tremel

The table artikel is like:

CREATE TABLE ARTIKEL (
ARTIKELNR PRIMKEY_D /* INTEGER */ NOT NULL,
CODE ARTIKELCODE_D /* VARCHAR(12) CHARACTER SET WIN1252 */,
...
VORSTEUERCODE PRIMCODEREF_D /* VARCHAR(10) CHARACTER SET WIN1252
*/,
UMSATZSTEUERCODE PRIMCODEREF_D /* VARCHAR(10) CHARACTER SET
WIN1252 */,
...
)^
ALTER TABLE ARTIKEL ADD CONSTRAINT PK_ARTIKEL
PRIMARY KEY (ARTIKELNR)^

ALTER TABLE ARTIKEL ADD CONSTRAINT FK_ARTIKEL_U_MWST
FOREIGN KEY (UMSATZSTEUERCODE) REFERENCES MWST (MWSTCODE)
ON UPDATE CASCADE
/* ON DELETE NO ACTION */^
ALTER TABLE ARTIKEL ADD CONSTRAINT FK_ARTIKEL_V_MWST
FOREIGN KEY (VORSTEUERCODE) REFERENCES MWST (MWSTCODE)
ON UPDATE CASCADE
/* ON DELETE NO ACTION */^