On Thursday 05 January 2006 04:58, nospam(at)hardgeus(dot)com wrote:
>That's not what foreign keys do. The only thing a foreign key
> provides is a guarantee that if any records in B (the referencing
> table) still reference a record in table A (the referenced table)
> then you cannot delete that referenced record.
Just a little nitpick: A foreign key will also guarantee that you can't
insert or update records with an fk in the referencing table that
doesn't match one already entered into the referenced table.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE