List of all tables that reference the cmn_location table

[mikeearnheart]

I would like to find a list of all tables that reference the CMN_LOCATION table.

I feel like I should be able to get this from the application but all that I have been able to do is use the 'Schema Map' to get a visual representation.  I would like to have a LIST of those references.

Regards,

Mike

[Onkar Pandav]

Hi,

Just go to dictionary and check any field is referring to this table; just change url to your instance

it would show active fields of type reference which are referring to cmn_location; you can then use the Table column to know which field belongs to which table using Group By

URL: https://instanceName.service-now.com/sys_dictionary_list.do?sysparm_query=active%3Dtrue%5Einternal_type%3Dreference%5Ereference%3Dcmn_location&sysparm_view=

Or

Go to sys_db_object.list

You will see all tables. Open "location" table.

Select field from form layout and select the field as Table->Extends table.

Refer below screen shot.

Mark helpful / correct based on your impact.