Hi all, If you get errors like these when you're creating a schema... "ERROR 42915: Foreign Key 'PIN_FK1' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would cause another table to be delete-connected to the same table through multiple paths with different delete rules or with delete rule equal to SET NULL.) '." "ERROR 42915: Foreign Key 'VC_FK3' is invalid because 'the delete rule of foreign key must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '."
...which table is it referring to when it says "the table" and "the same table"? The table to which the constraint is being added, or the table that is referenced by the constraint? It's really hard - for me at least - to work all of this out because I have c.500 tables in the schema and the relationships are quite complex; a table often has several FK constraints (and each of the referenced tables can have several FK constraints) and so it isn't immediately obvious which tables are causing the problem. Is there a way of getting Derby to provide more detail on exactly what the problem is? TIA Nick
