How to find out if one table is among descendants of another table?

[Andrii]

Hi,

I'm looking for ServiceNow functionality that would help me in finding out if any table is a child or among descendants of another table... is there such OOTB functionality?

[georgimavrodiev]

Hello Andrii,

Use the Application Navigator and navigate to System Definition > Tables.
Then select the table in which you are interested in and open its form. Go at the bottom. Under Related Links, there is an option called 'Show Schema Map'.
Click on it. There, you will be able to see all the connections / relations of that table.

Best Regards,Georgi Mavrodiev

IT Consultant

Do IT WIse

You may visit us in our Web Site: www.doitwise.com

[Andrii]

Oh,

I'm sorry - yes - that is what I need but I need to get it from Script, not manually

[jagarnathn · Accepted solution]

var table = new TableUtils("task"); gs.print(table.getTableExtensions()); 

*** Script: [incident, issue, kb_submission, sysapproval_group, change_request, change_request_imac, sc_task, problem, sc_req_item, ticket, ast_transfer_order, planned_task, change_task, change_phase, sc_request]

var table = new TableUtils("task"); gs.print(table.getAllExtensions()); 

*** Script: [task, incident, issue, kb_submission, sysapproval_group, change_request, change_request_imac, sc_task, problem, sc_req_item, ticket, ast_transfer_order, planned_task, change_task, change_phase, sc_request]

[Andrii]

I knew there should be something like this! Thank you so much! This is what I've been looking for!