Enterprise Data Manager Guide

Back Next

Specifying Integrity Constraints

The following information is available from the Details pane when you select a table from the Explorer pane:

Constraint Detail Tab	Function
General Information	Displays the name and description for the constraint.
Columns	Displays columns in the selected table with the name, data type, and check box to indicate if it serves as a primary key for the table.
Constraints	The constraint, with the following information: Name: A unique name for the constraint. Type: One of the values: CHECK, PRIMARY, REFERENTIAL and UNIQUE. Constraint: Specify a condition for the constraint. For example, CHECK (NumParts > 5). Enabled: There is also an option to disable a constraint, where it will not participate in defining data integrity of the respective table.

To view constraints on tables and specify new constraints, go to

View

Constraints

. The

Constraints

tab in the Explorer pane appears with the schema and its related tables in a hierarchy.

You can also create constraints between tables by using a drag-drop mechanism for target columns from the Canvas pane.