Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Salesforce Accelerator
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Importing Referential Integrity Constraints

Importing Referential Integrity Constraints

The following table explains each column of a sample Referential Integrity Constraints XLS file:
Column Name
Value
Table Name
Name of the Primary Table.
Constraint Name
Name of the Constraint.
Constraint Column
Column names where Constraint is imposed in the Primary and Secondary Tables.
Primary Key Name
Column name in the Primary Table which functions as its Primary key.
Ref Table
Secondary Table name.
Owner
Owner of the Primary Table (i.e. its Parent Application Module).
Ref Owner
Owner of the Secondary Table (i.e. its Parent Application Module).
Constraint Type
Type of Constraint (“R” for Referential Integrity).
Status
Specifies whether the Constraint is to be imposed currently.

0 COMMENTS

We’d like to hear from you!