Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › View Properties › Define a View in SQL Azure › Define a SQL Azure View Column Expression

Define a SQL Azure View Column Expression

After you have specified view columns in the SQL Azure 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 Azure physical model.

To define a SQL Azure view column expression

1. Click Views on the Model menu.

   The SQL Azure 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 Azure View Editor.

7. Click Close.

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