What is the table that holds the list of all CI Classes?

[Louis Evans]

I am building an application and I want to be able to read the settings specific to a class (not individual CI data).  For example;

• if a specific Effective Duration for a CI Class has been created I want to read that.
• if recommended fields have been assigned to a specific CI Class I want to be able to read what they are

Essentially I want to read CI Class level data, not the data of the CIs themselves.  Is there a table or tables I can access for this info? 

Thanks in Advance
Louis

[sachin_namjoshi]

You can get all CI class tables in sys_db_object table.

Regards,

Sachin

[Hitoshi Ozawa]

Table sys_dictionary holds all the columns of all the tables in ServiceNow. CI classes names all starts with "cmdb" to filter the list so "Table starts with cmdb".

[paki]

wrong, not every child class starts with cmdb

[Sandeep90 · Accepted solution]

Recommended fields can be obtained from the cmdb_recommended_fields table and the recommended column is a comma-separated field names list.