The customer would like to list the tables in the Altiris database (Symantec_CMDB).
What is the database Schema for the Symantec_CMDB?
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'