Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Default Value Properties › Add a Default or Initial Value for a SQL Azure Target Server

Add a Default or Initial Value for a SQL Azure Target Server

Add default or initial values to your SQL Azure data model to enforce the business rules of your organization. The rules that you create can establish a value, a list of values, or a range of acceptable values to store in a table, column, entity, or attribute. Use the SQL Azure Default Value Editor to add a default or initial value for a SQL Azure target server.

To add a default or initial value for a SQL Azure target server

1. Click Default Values on the Model menu.

   The SQL Azure Default Value Editor opens.

2. Click the New button on the toolbar.

   A new default value with a default name is added to the Navigation Grid.

3. Work with the following options:

   Physical Name

   Specifies the physical name of the default value. You can change the name in this field.

   Physical Only

   Specifies that the default value only applies to a physical model.

4. Click the SQL Azure tab and enter a server default value expression in the Value box. See your SQL Azure documentation for information on the syntax you can use in a default value expression.
5. Click Close.

   The default value is added and the SQL Azure Default Value Editor closes.

More information:

Default Value Properties