Domains and Data Modeling › Domains in the Physical Model › Specify a Validation Rule and Default Value for a Domain in the Physical Model

Specify a Validation Rule and Default Value for a Domain in the Physical Model

In a physical model, you can use the options in the Constraint tab in the Domain Editor to specify the validation rule and default value information associated with a domain.

To specify the validation rule and default value for a domain in the physical model

1. Click Domains on the Model menu.

   The Domain Editor opens.

2. Click the name of the domain in the Navigation Grid for which you want to specify a validation rule and default value.

   Note: To filter a large list of domains, enter the name (or the first few characters) of the domain for which you want to specify a validation rule and default value in the Enter filter text box.

3. Click the Constraint tab and work with the following options:

   Check Constraints

   Specifies the validation rule to attach to the selected domain. Select the validation rule that you want from the drop-down list. You can also use the drop-down list to open the Validation Rule Editor to view or modify an existing validation rule or create a new one. If the Use Inherited Constraint check box is selected this means that this property is inherited from the parent domain. If you do not want this property to be inherited, simply clear the check box and select a validation rule from the drop-down list.

   Default

   Specifies the default value to attach to the selected domain. Select the default value that you want from the drop-down list. You can also use the drop-down list to open the Default Value Editor to view or modify an existing default value or create a new one. If the Use Inherited Default Value check box is selected this means that this property is inherited from the parent domain. If you do not want this property to be inherited, simply clear the check box and select a default value from the drop-down list.

4. Click Close.

   The validation rule and default value is specified and the Domain Editor closes.

More information:

Specify a Validation Rule and Default Value for an Oracle Domain

Specify a Validation Rule and Default Value for a Teradata Domain