Table of Contents


  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Deleting Foreign Key Relationships

Deleting Foreign Key Relationships

You can delete any user-defined foreign key relationship that has been added. You cannot delete the system foreign key relationships that
Informatica MDM Hub
automatically defines and enforces to protect the referential integrity of your schema.
To delete a foreign-key relationship between two base objects:
  1. Start the Schema Manager.
  2. Acquire a write lock.
  3. In the schema tree, expand a base object and right-click
  4. On the Properties tab, click the foreign-key relationship that you want to delete.
  5. Click the
    The Schema Manager prompts you to confirm deletion.
  6. Click
    The Schema Manager deletes the foreign key relationship.
  7. Click the
    button to save your changes.


We’d like to hear from you!