Skip to main content Skip to complementary content
Qlik Resources
Announcements
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Enabling foreign key integrity checking

Availability-noteDeprecated
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.
  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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here