Stuart McLachlan
stuart at lexacorp.com.pg
Tue Mar 9 19:56:01 CST 2010
To me, the most importance role of referential integrity is with "deletes". Without RE, it is all too easy to get "orphaned" records. This can lead to all sorts of problems when trying to summarise data. -- Stuart On 10 Mar 2010 at 0:07, Asger Blond wrote: > But establishing foreign key constrains is a quite different beast. It > has per se nothing whatsoever to do with joining fields in *queries*: > it is there for enforcing consistency between values in different > fields when you are doing *inserts* and *updates*.