And, here is an example of implementing CASCADE option for table(s)
with PRIMARY Keys.
See attached screen shot for your viewing pleasure ...
Cascade - Maintains primary/foreign key relationships automatically.
A CASCADE can be
applied to UPDATE, DELETE, or BOTH data set changes for primary keys.
For example, if
you either UPDATE or DELETE a primary key value from a table, the
corresponding foreign
key values are updated or deleted automatically. CASCADE can only be
added to tables
with primary keys.
Update - enforces that when a primary key value is updated, the
corresponding value in
the foreign key table(s) will also be updated.
Delete - enforces that when a primary key value is deleted, the
corresponding value in
the foreign key table(s) will also be deleted.
Separate UPDATE and DELETE data restrictions can allow a CASCADE to
be enforced for
values that are updated, but not enforced when records are deleted,
in order to avoid
an accidental or undesired record delete.
Very Best R:egards,
Razzak
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
