Physical Modeling › Oracle Physical Property Editors › Oracle Table Column Editor › Define Default and Validation Constraints for an Oracle Column

Define Default and Validation Constraints for an Oracle Column

In a model based on the Oracle target server, you use the Constraint tab in the Table Column Editor to define Oracle default and validation constraints for the selected column.

To define default and validation constraints for an Oracle column

1. Right-click a column in the Model Explorer and click Properties.

   The Oracle Table Column Editor opens.

2. Select the table from the Table drop-down that contains the column that you want to define.
3. Select the column in the Navigation Grid that you want to define.

   Note: Click New on the toolbar to create a new column. Use the Enter filter text box to filter a very large list of columns to quickly locate the one that you want to define.

4. Click the Constraint tab and work with the following options.

   Check Constraints

   Specifies the validation rule to attach to the selected column. 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 column's 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 column. 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 column's 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.

   Constraint State

   Specifies the constraint state. Select the check box to enable this option and specify a True or False value for the following properties as needed:

   Deferrable

   Specifies whether constraint checking in subsequent transactions can be deferred until the end of the transaction.

   Immediate

   Checks the constraint at the end of each subsequent SQL statement

   Validate

   Specifies whether all old and new data complies with the constraint to guarantee that all data is valid and continues to be valid, or that only new operations on the constrained data comply with the constraint.

   Enabled

   Specifies whether to apply the constraint to the table data or to disable the integrity constraint.

   Rely

   Specifies whether to activate an existing constraint with NOVALIDATE set for query rewrite.

   Exception Table

   Lets you specify a table into which Oracle places the rowids of all rows that violate the constraint. The table you specify must exist on your local database.

5. Click Close.

   The default and validation constraints are specified and the Oracle Table Column Editor closes.