Table: CHECK Constraint

Use this page to optionally create or edit a check constraint.

A check constraint explicitly defines a condition. To satisfy the constraint, each row in the table must make the condition either TRUE or unknown (due to a null). For example, you could create a constraint on the SCOTT.EMP table that checks for department numbers greater than 10 (DEPNO > 10).

The check constraint can refer to any column in the current table, but not other tables.

Field Descriptions

New Constraints

Field	Description
Name	Enter a name that will identify the constraint.
Columns	Choose the column on which you want to base the constraint.
Operator	Choose the operator for the condition.
Value	Choose the value against which you want to check the column.
Add to List	Click to create the constraint. The new contraint will be added to the Existing Constraints list below.

Existing Constraints

Field	Description
Name	Displays the name of an existing constraint. Click if you want to delete the constraint. The deletion will be permanent. Clicking Cancel will not undo it.
Selected Columns	Displays the column on which the CHECK constraint is based.
Enable/Disable	Select to cause the Oracle database to enforce the constraint when its conditions are met. Deselect to disable the constraint.

Field

Description

Name

Displays the name of an existing constraint.

Click if you want to delete the constraint. The deletion will be permanent. Clicking Cancel will not undo it.

Selected Columns

Displays the column on which the CHECK constraint is based.

Enable/Disable

Select to cause the Oracle database to enforce the constraint when its conditions are met. Deselect to disable the constraint.

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Locating this Page

To locate this page in OracleAS Portal:

On the Portal Builder page, click the Navigator link.
Click the Database Objects tab.
In the Name column, scroll down to the schema in which you want to build the object.
Click the schema's name.
Click Create New...Table.
Complete each wizard page until you reach this page.