Replacing table dependencies in a data diagram after updating the SQL expression for a view

If you change the referenced tables in the SQL expression of a view, you can replace the table dependencies in the data diagram.

Before you begin

The data diagram that the view is in must be open in the diagram editor.

About this task

When you change the name of one or more tables in the SQL expression that defines a view, the table dependencies in the physical data model are replaced automatically. You can use a pop-up menu command to synchronize the table dependencies in the data diagram with the new table dependencies in the physical data model.

Procedure

To replace table dependencies in a data diagram after updating the SQL expression for a view:

  1. In the data diagram, click the view that contains the SQL expression that you want to update.
  2. In the Properties view, click the SQL tab.
  3. Change the name of one or more tables in the SQL expression. The existing table dependencies in the physical data model are replaced with new table dependencies that are based on the updated SQL expression for the view.
  4. In the data diagram, right-click the view, and then select Show Related Elements on the pop-up menu.

Results

The existing table dependencies for the view in the data diagram are replaced with new table dependencies that correspond to the table dependencies in the physical data model.

Feedback