Subject Re: [firebird-support] Foreign Key with Orphans?
Author Woody
From: "Scott Morgan" <blumf@...>
> Is it possible to have a FK child table where some of the rows FK values
> are not present in the parent table?

What's the point of a foreign key constraint if it doesn't work all the
time? That defeats the very purpose of it's design, IMO.

You will have to maintain it yourself if you want to break the rules. If you
want to automate certain parts of constraints, use triggers on the tables.
For instance, to only enforce the rule that child records get deleted with
the parent, put a before delete trigger on the parent table.

Woody (TMW)