Available in...
Data Fabric
MDM Platform
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.Enforce FK integrity enabled Enforce FK integrity disabled Allow FK integrity override enabled Delete allowed, with user prompted for override Delete allowed Allow FK integrity override disabled Delete forbidden Delete allowed 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. -