Subject RE: [IB-Architect] Rebuilding foreign keys system indexes
Author Ann Harrison
>
>
> > 3) Extend the foreign key constraint definition language with
> > the option [[IN]ACTIVE]....
>
>... tell the engine to allow any user to
>break the RI by not checking the FK declarations at all when inserting,
>deleting and updating?

Yes. That's what I meant. First, it means that reflexive constraints
can at least be documented. Second, it reduces the complexity of loading
data, especially if there's an ALTER CONSTRAINT [[IN]ACTIVE] and if the
system validates the data before activating an constraint.

Regards,

Ann