Creating Models › Target Servers for Physical Models › Database Property Editors › Common Property Pages › Select the Tables and Columns for the View or Join Index

Select the Tables and Columns for the View or Join Index

Use the Select tab to specify table or view columns in either the SQL Server View Editor or the Teradata Join Index Editor. You can create table column or view column references to any table or view column in your model. By default the table column or view column name reflects the column name that the table or view references, but you can change the name of the table column or view column. You can also reorder table columns or view columns.

To specify table or view column references for a view or join index

1. Open the property editor for either a SQL Server view or Teradata join index and click the Select tab.
2. Select the SQL Server view or Teradata join index in the Navigation Grid for which you want to specify column references.
3. Work with the following options:

   Available Tables and Views

   Lists the tables and views in the model that are available to use for column references. Click each table and view that you want to use, and click the right arrow button after each selection to add it to the Columns list.

   Note: The From tab of the editor is where you specify the tables or views that are shown in the Available Tables and Views list in the Select tab.

   Columns

   Displays the columns of each table or view you selected from the Available Tables and Views list. Use the up or down arrow buttons to move a selected column up or down in this list.

   Select Type

   Lets you select a view type that automatically eliminates duplicate rows.

   Name

   Lets you edit the name of a selected view column.

   Note: This field is not populated until you select a column in the Columns list.

   Expression

   Lets you edit the selected view column expression.

   Note: This option is available only if the selected view column is a user-defined expression.

   New

   Opens the New View Column dialog so that you can add a new view column expression to the selected view.

   Delete

   Deletes the selected view column expression.

   Note: You are not prompted to confirm the deletion; once you click the Delete button, the selected view column expression is immediately deleted.

4. Click Close.

   Column references are specified for the selected view or join index and the property editor closes.