On 24-1-2019 16:56, respekt...@post.cz [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
