Previous Topic: Define SQL Server 2008 View ColumnsNext Topic: Select the Tables and Views for a SQL Server 2008 View


Define a SQL Server 2008 View Column Expression

After you have specified view columns in the SQL Server View Editor, you can define a view column expression, which is a user-defined expression that is stored as a view column in either a SQL Server 2005 or 2008 physical model.

To define a SQL Server view column expression

  1. Click Views on the Model menu.

    The SQL Server View Editor opens.

  2. Select the view in the Navigation Grid that contains the view column for which you want to define a view column expression.
  3. Click the Select tab.
  4. Click the New button.

    The New View Column dialog opens.

  5. Enter information in the following fields:
    Alias

    Defines the view column expression name.

    Expression

    Defines the view column expression.

  6. Click OK.

    The view column expression is defined, the New View Column dialog closes, and you are returned to the SQL Server View Editor.

  7. Click Close.

    Your changes are saved and the SQL Server View Editor closes.