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. See Viewing tables with the same unique keys.
-
On the Search Results tab,
select a Table name.
A new search result opens with the headerTable Relation Type: Total match.
- On the bar at the top, click Same Unique Keys to display all the tables containing your selected index.
-
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:
Column heading Description Same Unique Keys (Column name) Name of the unique keys used by your selected table. Description Description of the keys used by your selected table. Sort order Sort order of the keys used by the table you selected. Ascending or Descending. -
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.
-
- You can also view table relations.