Enterprise Data Manager Guide

Back Next

Specifying Integrity Constraints

The following information is available from the Details Pane when a particular Table is selected from the Explorer Pane:

Constraint Detail Tab	Function
General Information	Displays name and description for the Constraint.
Columns	Displays Columns in the selected Table and with its Name, Data type and checkbox to indicate if it serves as a Primary Key for that table.
Constraints	The constraint, with the following information: Name: A unique name for the constraint. Type: This can take one of the values, CHECK, PRIMARY, REFERENTIAL and UNIQUE. Constraint: A condition for the Constraint can be specified here. 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 existing 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.