Physical Modeling › SQL Server Common Functionality › Define SQL Server View Column Properties

Previous Topic: Define SQL Server View Triggers

Next Topic: Define SQL Server XML Schema Collections

Define SQL Server View Column Properties

In a model based on either the SQL Server 2005 or SQL Server 2008 target server, you use the General tab in the View Column Editor to manage the domain parent, physical data type, and other properties for the selected column.

To define SQL Server view column properties

  1. Right-click a view column in the Model Explorer and click Properties.

    The SQL Server View Column Editor opens.

  2. Select the view from the View drop-down that contains the column that you want to define.
  3. Select the column in the Navigation Grid that you want to define.

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new column. Use the Enter filter text box to filter a very large list of columns to quickly locate the one that you want to define.

  4. Click the General tab and work with the following options:
    Domain Parent

    Displays the current parent domain. Use the toolbar to sort the domain list or open the Domain Editor to work with domains.

    Name

    Displays the view column name. You can change the name in this field or specify one of the following naming options:

    Inherit Button for Restoring Property Inheritance Inherit

    Specifies to inherit the view column name from the domain.

    Override Property Inheritance Override

    Specifies to override inheritance of the view column name.

    Harden Button for Hardening a Property or Name Harden

    Specifies to harden the view column name.

    Physical Data Type

    Displays the data type for the selected column.

  5. Click the Expression tab and enter a view column expression, which is a user-defined expression that is stored as a view column.
  6. Click the Indexes tab to manage index membership.
  7. (Optional) Click the Style tab to manage themes and display options for the view column.
  8. (Optional) Click the Where Used tab to view where the view column is used within the model.
  9. (Optional) Click the Comment tab and enter any comments that you want to associate with the view column.
  10. (Optional) Click the UDP tab to work with user-defined properties for the view column.
  11. (Optional) Click the Notes tab to view history information and view or edit user notes.
  12. Click Close.

    View column properties are defined and the SQL Server View Column Editor closes.