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 SQL Azure View Columns

Define SQL Azure View Columns

Use the SQL Azure View Editor to specify the view columns in a SQL Azure physical model. You can create view column references to any table column or view column in your model. By default, the view column name reflects the column name that the view references, but you can change a view column name. You can also reorder view columns, and create and manage view expressions, which are user-defined expressions that are stored as a view column.

To define SQL Azure view columns

1. Click Views on the Model menu.

   The SQL Azure View Editor opens.

2. Select the view in the Navigation Grid for which you want to define a view column.
3. Click the Select tab and work with the following options:

   Available Tables and Views

   Displays the tables or views and associated columns that can be used to define the view column. Click the tables or views that you want and use the arrow buttons to move the selected items from this list over to the Columns list.

   Note: You control the tables and views that display in the Available Tables and Views list using the options in the From tab.

   Columns

   Displays the available columns in the selected view. You can move a selected column up and down in the list.

   Select Type

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

   Restriction Type

   Lets you specify the With Check Option for the view column. This option ensures that data remains visible through the view after any changes are committed.

   Alias

   Lets you edit the alias 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 add a new view column expression to the view.

   Delete

   Deletes the selected view column expression.

4. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
5. (Optional) Click the Where Used tab to view where the object is used within the model.
6. (Optional) Click the UDP tab to work with user-defined properties for the object.
7. (Optional) Click the History tab to view the history information for the object.
8. (Optional) Click the Notes tab to view and edit user notes.
9. Click Close.

   View columns are defined and the SQL Azure View Editor closes.