In Teradata, the Domain Editor is used for viewing and managing domains in the physical model. Use the Constraint tab in the Domain Editor to specify check constraints and default values.
To specify the validation rule and default value for a Teradata domain
The Domain Editor opens.
Specifies the validation rule to attach to the selected domain. Select the validation rule that you want from the Validation Rule grid. If the Use Inherited Constraints 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 Validation Rule grid. The Check Constraints option contains a toolbar that includes the following options:
Sort
Sorts the list of validation rules by alphabetic, reverse alphabetic, or selected order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the validation rule list is currently sorted:
Specifies that the list is sorted in alphabetic order.
Specifies that the list is sorted in reverse alphabetic order.
Specifies that the list is sorted in selected order. This means that the validation rules that are currently selected go to the top of the list.
Opens the Validation Rule Editor so you can view or modify existing validation rules or create a new one.
Specifies the default value to attach to the selected domain. Select the default value that you want from the drop-down list. 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. 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.
The validation rule and default value is specified and the Domain Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|