Physical Modeling › Views › View Relationships Dialog › Define View Relationship Properties

Previous Topic: Add a View Relationship

Next Topic: Assign an Alias to the Source Table or View Referenced Through a View Relationship

Define View Relationship Properties

Use the Properties tab in the View Relationships dialog to define the properties of the selected view relationship.

To define view relationship properties

  1. Right-click the view relationship line for which you want to define properties and select Database View Relationship Properties.

    The View Relationships dialog opens.

  2. Specify properties in the following fields and click OK:
    Alias

    Lets you enter a new alias name or edit an existing alias name for the parent table or view in the selected view relationship.

    Sequence

    Lets you specify the position of the parent table or view that is referenced through the selected view relationship relative to other parent tables or views referenced by the view. The sequence you specify determines the order of the tables or views in the FROM clause of the CREATE VIEW statement.

    FROM

    Displays the order of the parent tables or views in the FROM clause of the view. The order that is displayed is determined by how you specified the order in the Sequence field.

    View relationship properties are defined and the View Relationships dialog closes.