Meaning of Referential Integrity ("on parent update") Notation

E

ekreutzer

When I create an ER diagram in Visio, and I have created a relationship, I
can select the "Referential Action" property under "Categories" and set it to
one of the following:

On parent update OR On parent delete
No Action
Cascade
Set NULL
Set default
Don not enforce

The notation displayed on the diagram is
u:R
d:R
if I have "No action" selected.

What does the "R" stand for?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enforcing referential integrity across databases 4
Referential Integrity Issues 5
referential integrity and lookup 2
Parent Tables and Referential Integrity 3
Referential Integrity Q 3
Referential integrity and join type 2
Referential integrity and junction tables 3
referential integrity and possible orphans 2

Top