View Relations

Top  Previous  Next

A View Relation is very similar to a Table Relation, except the Child of the Relation is a View.  A View Relation has the same properties as a Table Relation, however the database does not enforce the referential integrity of a View Relation.  i.e. in Oracle it must always be created as DISABLE NOVALIDATE.  Hence, View Relations are primarily used just for documentation purposes.

View Relations are represented in a Diagram with a View Relation Graphic object.  A View Relation Graphic Template is provided so that you can easily change the appearance of all View Relations.

You can toggle the display of all View Relations in the Diagram's Relation Display Options Property Page. You can also toggle the display of any individual Relation by selecting the Relation, then selecting the Graphic tab in the Property Browser, and toggling the Display checkbox.