Alternate Key Manager

This XrmToolBox tool allows you to manage the alternate keys across multiple tables of the Microsoft Dataverse environment (developed by Jim Novak).

Alternate keys can be managed in the out-of-the-box table designer but it can only show the keys for the selected table and it can be time-consuming to open up multiple tables to find out which ones are failing.

To view all the keys of multiple tables and their status at the same place, you can use this tool to select multiple tables and load the keys for those tables.

• Tool Information
• Documentation
• Functionalities
• List alternate keys for selected tables (Fig. 1, Pt. 4)
• View details of the selected alternate key (Fig. 1, Pt. 7 and Pt. 8)
• Activate the key if an Alternate Key is in an error state (Fig. 1, Pt. 5)
• Delete an Alternate Key is in an error state (Fig. 1, Pt. 6)
• Create a new Alternate Key (Fig. 1, Pt. 9) (Fig. 2)
• Additionally, the tool can
• Load all tables from the environment (Fig. 1, Pt. 1)
• Show system and custom tables separately (Fig. 1, Pt. 11)
• Select all tables or none (Fig. 1, Pt. 2)
• Allow filtering of tables by display or schema name (Fig. 1, Pt. 3)
• Save/load selected tables for next time (Fig. 1, Pt. 10)

Fig. 1 - List of Tables and Alternate Keys for Selected Tables

Fig. 2 - Create New Alternate Key

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.