Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2005 Property Editors › Define SQL Server 2005 Views › Define a SQL Server 2005 View Column Expression

Define a SQL Server 2005 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 and then select the view column you want to work with in the Columns list.
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.