Enterprise Data Catalog User Guide > Part I: Discovery > View Relationships > Viewing Asset Relationships
  

Viewing Asset Relationships

You can view related assets from the Relationships view. When you open an asset from the Relationships view, the asset opens in the Relationships tab. To view the basic properties of the asset, switch to the Overview tab.
To open the assets in the circle, click the name of the asset that you want to open.

Viewing keys of related tables

Click Show All on the Tables circle of the Relationships view to view the type of relationship between a tabular asset and the related tables. You can view the relationship between a tabular asset and the primary and foreign keys of related tables.
    1. Open the Relationships tab of a tabular asset.
    2. Click the Tables circle to display all the related tables.
    The following image shows the Relationships tab of a tabular asset: The image shows the relationship between the STUDENT_DETAILS table and the foreign and primary keys of the related tables.
    Note: You can click the name of a related table directly from the Tables circle.
    3. Click Show All to view the type of relationship between the asset and the related tables. The Tables dialog box appears.
    The following image shows the Tables dialog box: The Tables dialog box shows the type of relationship between the STUDENT_DETAILS table and the related tables.
    4. Click a value in the Names column to view the relationship of the related table.
    The following image shows the Relationships tab of a related table: The image shows the relationship between the STUDENT_DETAILS table and the STUDENT_BRANCH_DETAILS2 table.
    5. Click Primary Keys in the Relationship column to view the foreign keys of the related table.
    The following image shows the Foreign Keys tab of a related table: The image displays the Keys tab that contains the Foreign Keys section. The Foreign Keys section contains details of foreign keys such as Key Name, Columns, Description, and Business Title.
    For more information about the foreign key details of an asset, see Viewing the Foreign Key Details.
    6. Click Foreign Keys in the Relationship column to view the unique keys of the related table.
    The following image shows the Unique Keys tab of a related table: The image displays the Keys tab that contains the Unique Keys section. The Unique Keys section contains details of unique keys such as Key Name, Columns, Description, Confidence Score, and Type.
    For more information about the unique key details of an asset, see Viewing the Unique Key Details.
    Note: Effective in version 10.5.2.1, you can view the unique keys and foreign keys of related assets from the Relationships view of a tabular asset.