Adding table dependencies and their associated views to a data diagram

You can add table dependencies and their associated views to a data diagram either selectively or collectively.

Before you begin

Ensure the following requirements are met:
  • The data diagram that you want to add table dependencies and their associated views to must be open in the diagram editor.
  • The table that you want to add dependency relationships for must be in the data diagram.

About this task

The dependency relationships for a table are listed under the table in the physical data model in the Data Project Explorer. Similarly, the dependency relationships for the associated views are listed under the views in the model. The table dependencies are listed only for the views that are in the same model as the table.

Procedure

To add table dependencies and their associated views to a data diagram:

Perform one of the following actions:
Option Description
To add the dependency relationships selectively In the physical data model under a table, select the dependencies and then drag them to the data diagram.
To add the dependency relationships collectively In the data diagram, right-click a table, and then select Show Related Elements.

Results

All or the selected subset of the dependencies for the table and their associated views are added to the data diagram.

Feedback