# Enabling foreign key integrity checking

Availability-note[Deprecated](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-deprecated)

This content is deprecated.

Available in...

* Data Fabric
* MDM Platform
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition

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

1. 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.

   ![](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/fk-integrity-check.png)
2. Select the entity containing the foreign key for which you want to enable integrity checking.
3. In the Properties view, click the Relationship tab.
4. 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.

### In this section

* [Handling circular dependencies](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-10/handling-circular-dependencies)