Here the create sqls CREATE TABLE ZEUGNIS_FORMULAR ( ID BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, VERSION BIGINT NOT NULL, AUSGABE_DATUM TIMESTAMP NOT NULL, BESCHREIBUNG VARCHAR(50) NOT NULL, KLASSE_ID BIGINT NOT NULL, LEITSPRUCH VARCHAR(300), LEITSPRUCH2 VARCHAR(300), NACHTEILS_AUSGLEICHS_DATUM TIMESTAMP NOT NULL, QUELLE_LEITSPRUCH VARCHAR(30), QUELLE_LEITSPRUCH2 VARCHAR(30), SCHULHALBJAHR_ID BIGINT NOT NULL, TEMPLATE_FILE_NAME VARCHAR(255) NOT NULL, CONSTRAINT PK_ZEUGNIS_FORMULAR PRIMARY KEY (ID));
and CREATE UNIQUE INDEX UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG ON ZEUGNIS_FORMULAR(KLASSE_ID, SCHULHALBJAHR_ID, BESCHREIBUNG); I can provide the whole database or the complete SQL-scripts if it helps. Niels Am Donnerstag, 18. Oktober 2012 20:09:16 UTC+2 schrieb niels: > > I try the following > DROP INDEX UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG; > > and get > [Error Code: 90085, SQL State: 90085] Index > "UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG" gehört zu einer Bedingung > Index "UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG" belongs to a > constraint; SQL statement: > DROP INDEX UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG [90085-149] > > I followed the documentation and try > SELECT * FROM INFORMATION_SCHEMA.CONSTRAINTS > WHERE UNIQUE_INDEX_NAME = > 'UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG'; > But the result is empty. > > Calling > ALTER TABLE ZEUGNIS_FORMULAR DROP CONSTRAINT > UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG; > > returns > Constraint "UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG" not found; > SQL statement: > ALTER TABLE ZEUGNIS_FORMULAR DROP CONSTRAINT > UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG [90057-149] > ALTER TABLE ZEUGNIS_FORMULAR DROP CONSTRAINT > UK_ZEUGNIS_FORMULAR_HALBJAHR_KLASSE_BESCHREIBUNG; > > To make it reproducible I tried just to create the one table and the > constraints. As a result I figured out that it seems to be a problem with > some foreign keys, because if I don't create them all works fine. > > Can someone give me a hint how to find the reason. I can't understand why > I can't drop the INDEX. > > Regards > Niels > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/Ab730i_V76gJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
