---
sourceDocument: Australia ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/platform-administration

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Analyzing table relationships

# Analyzing table relationships {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Analyzing Table Relationships

The schema map provides a visual representation of a selected table and its related tables, allowing users to analyze relationships effectively.
The selected table is highlighted, while related tables are displayed around it, with customizable views for relationship types.
Show full answer Show less  

## Key Features

* **Schema Map Visualization:** Tables are visually represented, with relationship types controlled by checkboxes at the top.
* **Table Selector:** Users can scroll to tables or show/hide them using the eye icon in the table selector. The pin icon keeps the list open for ongoing reference.
* **Context Menu Functions:** Right-clicking a table header provides options such as focusing on that table, viewing its records, or accessing the system dictionary.
* **Derivation Hierarchy:** Users can expand tables to view their derivation hierarchy and columns, with reference fields clearly indicated.

## Key Outcomes

By utilizing the schema map and table selector, ServiceNow customers can better understand table relationships, navigate data structures efficiently, and access relevant information about each table's fields and hierarchy. This enhances data management and decision-making processes within the ServiceNow platform.  
The schema map shows the selected table in yellow, typically centered, and all tables
related to that table, typically shown at the sides.  
Figure 1. Example schema map  
From this map:

* The check boxes at the top allow you to control which relationships to display. Select or clear a relationship type to display or hide tables with that relationship to the selected table.
* Each related table has a colored bar indicating the relationship to the selected table.
* You can point to the connector lines to display the details of a relationship between the two tables.

{#c_ViewTheSchemaMap__ul_dvf_fzm_hp}  
Note:  
Since relationships are shown as single lines for simplicity, the diagrams rendered are not entity relationship diagrams.

Using the Table Selector:

To view a schema map as a list, point to the table selector in the right corner:  
You can:

* Click a table in the list to scroll the schema map to that table.
* Click the eye icon beside a listed table to hide or show that table in the schema map.
* Click the pin icon in the selector to keep the list open.
{#c_ViewTheSchemaMap__ul_l3w_mzm_hp}

Using Related Tables:  
Right-click a table node header to display a context menu with these functions:

* Focus on this table: Make the selected table the new focus table and redraw the schema map based on the new selection.

  The new focus table is added as a
  breadcrumb at the top, allowing you to return to the previous table at any
  time.
* Go to list: Display the list of records for the table.
* Go to dictionary: Display the system dictionary, filtered for the selected table.
{#c_ViewTheSchemaMap__ul_slc_qzm_hp}

To hide a related table from view, click the eye icon in the node header (the node can be
made visible again with the table selector).

For tables that are part of their own derivation hierarchy, click the expand button
(+) in the node header to add their derivation hierarchy to the
schema map.

## Viewing More Information

Click the expand button (+) beside Columns to expand the table fields.

The reference fields show a red notation of the table they refer to.

If any tables extend from a table, their columns are displayed in reverse derivation order. For example:

Here, the Server `[cmdb_ci_server]` table extends from Computer
`[cmdb_ci_computer]`, Hardware` [cmdb_ci_hardware]`, and
Configuration Item `[cmdb_ci]`, and displays the columns from those
tables.

Similarly, the Computer table displays the columns from the Hardware and Configuration Item
tables.