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.
To
replace table dependencies in a data diagram after updating the SQL
expression for a view:
- In the data diagram, click the view that contains the SQL
expression that you want to update.
- In the Properties view, click the SQL tab.
- 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.
- 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.