Confirming all database primary keys and indexes are in place

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager
• ServiceDesk

Issue/Introduction

While investigating a problem with our MDB database we found that a certain table in the database was missing its primary key index.  What would be a good way to check the MDB database to ensure that all tables have the appropriate primary keys and indexes defined.

Environment

Service Desk Manager v17.x

Resolution

Service Desk does not have a utility that does this, nor a utility that will simply drop and rebuild all the indexes. An upgrade might help to replace some indexes, but that's dependent on what patches were or were not installed in the previous release.

The best option might be to use SQL Server Management Studio to export the database schema for the database that is questionable, and compare with the same export from another database where you know everything is correct.