Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Common Functionality › Define Validation Rule Usage for a SQL Server Table

Define Validation Rule Usage for a SQL Server Table

Use the SQL Server Table Editor to specify constraints on a table in either a SQL Server 2000, 2005, or 2008 physical model.

To define validation rule usage for a SQL Server table

1. Click Tables on the Model menu.

   The SQL Server 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 Server 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 whether to disable the validation in the database. Select a value from the drop-down.

   Is Not For Replication

   Specifies whether the validation is not for replication in the database. Select the check box to enable this option.

   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 Server Table Editor closes.