Viewing same unique keys

Before you start, you must complete a table search task and display the index relation information on the Search Result tab.

  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, click Same Unique Keys to display all the tables containing your selected index.
  3. On Key Info column, click View Same Unique Keys to view the same unique key.

    A new search result named after your selected table to Same Unique Keys , opens with this information:

    Same Unique Keys (Column name)
    The name of the unique keys used by your selected table.
    Description
    The description of the keys used by your selected table.
    Sort order
    The sort order of the keys used by the table you selected. Ascending or Descending.
  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, specify a dynamic free text filter for each column and select a Filter action.

  5. You can also view table relations.
    See Viewing Table and Column Relation Information.