How can I list the tables in the Altiris database?

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

The customer would like to list the tables in the Altiris database (Symantec_CMDB). 

What is the database Schema for the Symantec_CMDB?

Resolution

When you run the following query on the Symantec_CMDB, it will list the tables that are in the database.

SELECT * FROM information_schema.tables;

When you run the following query on the Symantec_CMDB, it will list information about the columns in the table.

SELECT * FROM INFORMATION_SCHEMA.columns c WHERE c.table_name = 'DBSchema'