<< Click to Display Table of Contents >>

Add Check Constraint

Top Previous Next

This dialog allows you to create a check constraint. Enter the name of the check constraint to be created into the edit box.

Type the check condition in the memo field below. You can copy the selected column name(s) from the list box on the right by clicking the arrow button.

Using a radio group, you can select the status the constraint should have after creation:

Enabled

Enabled, but existing data will not be validated. (This requires an Oracle 8 Server, or higher)

Disabled.

You can also enter an exceptions table name that will store the rowids of all table rows not matching the constraint.

After the OK button is pressed, the operation is performed. If you change an existing constraint, Hora drops it and creates a new one with the changed syntax. If doing this raises an exception, Hora re-creates the constraint with the old syntax.

The Cancel button closes the dialog without any action.