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

Define SQL Azure Domain Properties

In a model based on a SQL Azure target server, you use the SQL Azure tab in the Domain Editor to manage the data type, null option, and other properties for the selected domain.

Note: The options described here are the basic options available for most physical data types. There can be more options available depending on the physical data type you assign to the domain. We recommend that you refer to your SQL Azure documentation for more information about using these properties.

To define SQL Azure domain properties

1. Click Domains on the Model menu.

   The Domain Editor opens.

2. Select the domain in the Navigation Grid that you want to define.

   Note: Click New on the toolbar to create a new domain. Use the Enter filter text text box to filter a very large list of domains to quickly locate the one that you want to define.

3. Click the SQL Azure tab and work with the following options:

   Code Type

   Identifies SQL as the code type for the column.

   Physical Data type

   Lets you select a data type from the drop-down list to apply to the selected domain. If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. For example, you can select the DECIMAL() data type and specify a precision of 2 and a scale of 10 inside the parentheses to assign the data type DECIMAL(2,10) to the selected domain.

   Null Option

   Lets you specify a null option.

   Average Width

   Lets you enter an estimated average width for columns if variable width is allowed based on the data type you assigned. If it is not allowed, an error is displayed in the Details section at the bottom of the editor. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

   Percent Null

   Lets you enter the estimated percentage of nulls used for columns if the option is available. Use whole numbers. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

   Populate All Rows With Default Value

   Specifies to populate new rows with default column values. Select the check box to enable this option.

   Persisted

   Specifies that a computed column is PERSISTED. A column marked PERSISTED is physically stored in a table and not a virtual column. When you select the check box for this option, enter the expression to use to define the value of the computed column in the SQL text area of the Expression option.

4. Click Close.

   Domain properties are defined and the Domain Editor closes.