Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › Table and Column Properties › Define a Table in SQL Azure › Define Validation Rule Usage for a SQL Azure Table

Define Validation Rule Usage for a SQL Azure Table

Use the SQL Azure Table Editor to specify constraints on a table in a SQL Azure physical model.

To define validation rule usage for a SQL Azure table

1. Click Tables on the Model menu.

   The SQL Azure Table Editor opens.

2. Select the table in the Navigation Grid for which you want to define validation rule usage.

   Note: Use the Enter filter text box to filter a very large list of tables to quickly locate the one for which you want to define validation rule usage.

3. Click the Validation tab.
4. Select the validation usage item in the grid that you want to define and work with the following options:

   Note: Click New on the toolbar to open the SQL Azure Validation Rule Editor if there are no validations displayed in the grid.

   Validation

   Specifies the name for the usage of the validation rule by the table. Change the name in this field.

   Disabled

   Specifies that validation is disabled in the database. This property is always set to True.

   With Check

   Specifies whether the With Check constraint property is set for the validation.

   Validation Rule

   Specifies the validation rule to associate with the validation rule usage name specified in the Validation field.

5. Click Close.

   The validation rule usage is defined and the SQL Azure Table Editor closes.