You can enable foreign key integrity checking to manage whether users are allowed
to delete a record that is linked to another record through a foreign key. By default,
this is not allowed.
About this task
To enable foreign key integrity checking:
Procedure
-
In the MDM Repository tree view, expand the
Data Model node and double-click the data model for
which you want to enable foreign key integrity checking.
The corresponding editor opens with the selected data model displayed.
-
Select the entity containing the foreign key for which you want to enable
integrity checking.
-
In the Properties view, click the
Relationship tab.
-
Under the Foreign Key section:
- Select the Enforce FK integrity check box to enable
foreign key integrity checking, that is, to raise an error whenever a user
tries to delete a record if the record is linked to any other records through
this foreign key.
- Select the Allow FK integrity override check box to
allow users to force the delete of a record even if it is linked to another
record through this foreign key.
These two options can be combined in the following ways:
- If both Allow FK integrity override and
Enforce FK integrity are enabled, users can delete a
linked record and are prompted for override.
- If Allow FK integrity override is enabled and
Enforce FK integrity is disabled, users can delete a
linked record.
- If Allow FK integrity override is disabled and
Enforce FK integrity is enabled, users cannot delete
a linked record.
- If both Allow FK integrity override and
Enforce FK integrity are disabled, users can delete a
linked record.
In the case of conflicts, the least tolerant rule is always applied.
If a user is prevented from deleting a record, details are provided in
<$INSTALLDIR>/logs/mdm.log.