Viewing tables with Foreign Key relation

Note: The CONO and DIVI column keys are used by most of the BE tables. These keys are not included in the unique key comparison.

Before you start, you must complete a table search task.

  1. On the Search Results tab, select a Table name.
    A new search result opens with the header Table Relation Type: Total match.
  2. On the bar at the top, select Foreign Keys to display a list of selection with foreign keys used.
    A new search result opens with this information:
    Table Name
    The name of the table used by your selected program.
    Description
    The description of the panel used by your selected program.
    Importance Rank
    The total number of programs with semantic importance relation between two tables.

    To view programs of importance rank relation, click the importance rank number.

    Key Info
    An option to view foreign keys.

    To view foreign keys relation, click View Foreign Keys.

  3. Use these options to sort and filter your results.

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, specify a dynamic free text filter for each column and select a Filter action.