<< Click to Display Table of Contents >>

Tables - Constraints

Top Previous Next

This sheet shows the constraints on various table columns. Clicking on the plus sign to the left of the constraint name brings up a popup window with additional information.

The grid shows the following:

Constraint name

DDL-Definition of the primary key, unique, foreign-key or check constraint

Is the constraint deferrable?

Is the constraint immediately deferrable?

Object status (ENABLED, DISABLED)

Was this constraint system-validated?

Constraint name corresponding to an index. Reminder: Oracle recommends that you create an index on foreign key columns, since this should prevent a full table lock of the detail table after a row of the referenced master table is updated.

Last change time stamp, i.e. the date when this constraint was last enabled or disabled.

frmTables_Constraints

 

In the example above, two plus signs have been clicked—one for a foreign key, with Referenced constraints selected, and one for a check constraint, with Columns selected.

The following context operations are available from the grid:

TablesConstraintsAddPrimary

Add Primary Key, Unique

Shows a modal dialog for adding the new primary key or a new unique constraint to the table.

TablesConstraintsAddForeign

Add Foreign Key

Shows a modal dialog for adding a foreign key to another table.

TablesConstraintsAddCheck

Add check

Shows a modal dialog for adding a check constraint to the table.

PROPERTIES

Properties/Alter/Rename

Shows a modal dialog for viewing and modifying the primary key/unique key , foreign key or check constraint definition. KeepTool drops and re-creates the constraint to perform changes in the constraint definition. If an exception occurs, KeepTool re-creates the constraint with the saved old definition.

TablesDrop

Drop

Drops the selected constraint(s).

 

Show DLL

Shows the DDL statements to add the constraint.

 

Create index on FK columns ...

Shows the Create index dialog for creating an index on the foreign key columns.

ENABLE

Enable

Enables a disabled constraint.

DISABLE

Disable

Disables a constraint.

TablesConstraintsExceptions

Show Exceptions

Shows all rows not conforming to a disabled or non-validated constraint.

 

Copy to clipboard

Shows a submenu to copy either the constraint name or a generated WHERE col1 = :col1 ... AND coln = :coln condition condition to the Windows clipboard.

 

Grid View

For more information, see object window