Viewing Foreign Key

Before you start, you must complete a table search task. See Searching for table.

  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.
  3. On the Key Info column, click View Foreign Keys corresponding to your selected table to view.

    A new search result opens with this information:

    Column heading Description
    Foreign Key Displays the foreign key column name
    Description Description of the panel used by your selected program.
    Sort order The order in which the foreign key view appears.
  4. 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, type a dynamic free text filter for each column and select a Filter action.