Listing of tables/schema configuration in MDB database

Products

• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager
• CA Service Catalog

Issue/Introduction

Is there a way to determine or obtain a list of all of the tables that are defined in a given MDB database?

Environment

CA Service Management - all versions

Resolution

One can query the mdb_schema_information table in the MDB database.  This table contains a list of all such tables and a record of schema updates logged.

For example, if the MDB is installed on SQL Server, the following query will list all of the MDB tables:

select * from mdb_schema_information where FileType = 'table'