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/-/dWV4veIJ--MJ. 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.
