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.
-
On the Search Results
tab, select a Table name.
A new search result opens with the header Table 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:
- 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.
-
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.
-
- You can also view table relations.