Previous Topic: Enter a View Relationship CommentNext Topic: Materialized Views


Change the Sequence of the Tables Referenced by a View

Changing the sequence of the tables referenced by a view in a physical model determines the order in which the schema for the view is generated.

To change the sequence of the tables referenced by a view

  1. Right-click the relationship between the view and the source table or view, and select Database View Relationship Properties.

    The View Relationships dialog opens.

  2. Click the Properties tab.

    The Properties tab opens.

  3. Select the position of the source table or view relative to the other source tables or views referenced by the view in the Sequence box and click OK. The read-only text below the Sequence box shows the order of the tables and views in the FROM clause of the view.

    The sequence is changed and the View Relationships dialog closes.

More information:

Define View Relationship Properties