On 24-1-2019 16:56, respektive@... [firebird-support] wrote:

> 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

What is your Firebird version? Have you tried backing up and restoring
the database instead of copying? Have you tried validating the database
with gfix?

Mark
--
Mark Rotteveel