How to get the list of all the tables extended from base table and their unique columns as well?

[Ajay37]

Hi,

For suppose if I have a table A extended from base table cmdb_ci which can be further extensible. Now I extended table B from table A and in the same way table C from table B. Table C is someway related to base table cmdb_ci and it has all the columns of cmdb table. Now I am trying to write a script, which get all the tables somehow related to cmdb_ci. Like in this example, I need to get list like A, B, C even B and C are not direcly extended from cmdb_ci, I want them in list.

And also, I want to get the unique columns list in A, B, C which shouldn't extended from parent table. Could anybody has an idea on achieving this?

Thanks

[Ajay37]

Hi @sureshloganathan ,

Thank you. But I want the chain of tables somehow related to specific table cmdb_ci. I think with filters it can't be possible.

[ersureshbe]

Hi, 

Can you go to cmdb_ci table under related list refer below highlighted link. You will get the complete list of tables relaetd to cmdb_ci

else,

try below in the tables and get the result

Please mark as correct answer if it helped.

Regards,

Suresh