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

 

Reply via email to