Subject Re: [firebird-support] Foreign Key with Orphans?
Author Scott Morgan
Helen Borrie wrote:
> At 04:06 AM 3/12/2008, you wrote:
>> Is it possible to have a FK child table where some of the rows FK values
>> are not present in the parent table?
> No - if that were possible, it wouldn't be an INTEGRITY constraint, would it? But, out of curiosity, WHY?

Change of business 'logic', I need to start supporting external parents
with different attributes to the original. In the long run I'd create a
master parent table which the original parent becomes a child of along
with the other child tables, however that means a lot of work I don't
have time for right now.

Had a feeling it wouldn't be possible this way, just wanted to be sure,