How to differentiate between inherited fields and created in the same table.

[Anupriya1]

Hi All,

Can someone help me in identifying the fields created on a specific table and the fields inherited by that table from its parent table.

I am unable to find any specific column for the same.

Thanks in Advance!

[Anupriya1]

Hi Harshvardhan,

I have checked it, in my case total 145 records are there and it is showing the table name as the same table in which I am checking. But it has most of the fields inherited.

Thanks.!

[Harsh Vardhan]

add screenshot of your table. which table has been used in "Extends Table" column ?

[Anupriya1]

Hi Harshvardhan,

My table is the extension of Computer table. As you can see in the screenshot, it is showing me the same table name everywhere rather these fields are the extended ones.

[Harsh Vardhan]

do one thing. 

Go To System Definition >> Tables & columns >> search your table there >> you will see "Schema Map" button click on that , it will show the details in one frame. 

Screenshot for reference. 

 

eg: incident i have selected to you will select your table there. 

Doc link for further details. 

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/table-administrat...

[Omkar Joshi]

Hi,

In dictionary you can see two different table names for child table fields and parent table fields.