[EMAIL PROTECTED] wrote:
> Hello all,
>
> Without explicitly creating foreign keys, what is the most common method to
> create a truly relational database that enforces referential integrity?
>
> Any responses to this question are greatly appreciated!
>
> Sincerely,
>
> N. Silverwise
>
Referential Integrity is a two-edged sword. If you aren't careful you can rip the guts
out of your db with interlaced cascading deletes. You generally need pin-point control
in a complex relation. I prefer the finer control I have doing it in code.
If you are looking for a completely compliant RDBMS then you shall be looking for some
years yet, as ALL of the offerings out there depart to some degree or another based on
the design decisions of the developers.
danh
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
