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

Anupriya1 · ‎12-30-2019

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!

Ashley Snyder1 · ‎12-30-2019

@Anupriya you mentioned your table was an extension of a cmdb table: cmdb_ci_computer. Have you looked at the CI Class Manager to get this information? You should be able to click "Hierarchy" and find your table, from there navigate to the "Attributes" tab and you'll see selections for Derived and Added fields:

https://docs.servicenow.com/bundle/newyork-servicenow-platform/page/product/configuration-management...

View solution in original post

Anupriya1 · ‎12-30-2019

Hi Omkar,

In dictionary, you mean to sys_dictionary or dictionary or each field.

Omkar Joshi · ‎12-30-2019

Also you can use Table and columns module.

Anupriya1 · ‎12-30-2019

Hi Omkar,

Thanks for you reply!

Please see in the screenshot, this doesn't work for every field.

Dhananjay Pawar · ‎12-30-2019

Hi,

Another way is navigate to sys_db_object.list it will give you all table list search for child table name and open that table record. Under column section you will find all the fields and their description(which are inherited and which are custom).

Check below screenshot for reference.

Mark correct/helpful based on impact.

Thanks,

Dhananjay.

Anupriya1 · ‎12-30-2019

Hi Dhanajay,

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.

So, I am not able to differentiate.