Define View Columns

Physical Modeling › Views › View Editor › Define View Columns

Use the Select tab in the View Editor to define view columns. The following options are available to define view columns:

Create view column references to any table column or view column in your model.
Change a view column name. By default, the view column name reflects the column name that the view references.
Reorder view columns.
Create and manage view expressions, which are user-defined expressions that are stored as a view column.

To define view columns

Right-click the view in the Model Explorer for which you want to define a view column and click Properties.
The View Editor opens.
Click the Select tab and work with the following options:

Available Tables and Views

Displays the names of the tables or views and associated columns that can be referenced by the selected view. Double-click a column in this list to move it to the Columns list to include it in the selected view, or double-click a table or view to move all of its columns to the Columns list and include them in the selected view.

Note: Available tables and views are determined by the tables and views selected in the From tab.

Columns

Displays the view columns assigned in the selected view.

Select Type

Lets you specify the Distinct option so that the view automatically eliminates duplicate rows.

Restriction Type

Lets you specify the With Check Option so that all changes made through the view to the underlying tables satisfy the definition of the view.

Alias

Lets you edit the name of the selected view column.

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 you can enter a user-defined expression as a view column.

Delete

Specifies to delete the selected expression.
Click Close.
View columns are defined and the View Editor closes.