Table: UNIQUE Constraint

Use this page to optionally create or edit a unique constraint on a column.

A unique constraint requires that no two rows of a table have duplicate values in a specified column or set of columns.

Field Descriptions

Field	Description
Name	Enter the name that will identify the constraint.
Columns	Choose one or more columns on which to base the constraint, then click Add to List.
Add to List	Click to create the constraint. The new constraint will be added to the Existing Constraints list below.

Field	Description
Name	Displays the name of a UNIQUE constraint that currently exists for the table. Click if you want to delete the constraint. The deletion will be permanent. Clicking Cancel will not undo it.
Selected Columns	Displays the table column or columns on which the 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 a UNIQUE constraint that currently exists for the table.

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

Selected Columns

Displays the table column or columns on which the 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.

If you are editing the definition of a currently existing table that contains data, an error may occur if you try to create a new constraint.

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.