| Subject | Why I cannot remove FK constraint |
|---|---|
| Author | |
| Post date | 2019-01-24T15:56:43Z |
Hello
I have problem with part of our databases.
All our databases should have the same structure, but in some of them I cannot drop constraint
ALTER TABLE VYKONY_AUT DROP CONSTRAINT FK_VYKONY_AUT_VYKON chyba: java.sql.SQLSyntaxErrorException: unsuccessful metadata update; ERASE RDB$RELATION_CONSTRAINTS failed; action cancelled by trigger (1) to preserve data integrity; Cannot delete trigger used by a CHECK Constraint; At trigger 'RDB$TRIGGER_34' [SQLState:42000, ISC error code:335544351] java.sql.SQLSyntaxErrorException: unsuccessful metadata update; ERASE RDB$RELATION_CONSTRAINTS failed; action cancelled by trigger (1) to preserve data integrity; Cannot delete trigger used by a CHECK Constraint; At trigger 'RDB$TRIGGER_34' [SQLState:42000, ISC error code:335544351]
I don't know what happens in these databases - they look same as databases in which it works.
I tried to copy database and drop this table (at first I drop all objects that depend on this table) - but it does not help
Thank you in advance
Tomas