question How to find a field which is inherited on hundreds of tables in ITSM forum

How to find a field which is inherited on hundreds of tables

LeelanathRP — Thu, 15 Jan 2026 04:15:58 GMT

Hi All,

I have one filed which was inherited on 400+ tables, so now instead of hard code deactivating on all tables I need to find this field parent table so if I deactivated there than it takes down on all 400+ tables please tell me the best approach.

Re: How to find a field which is inherited on hundreds of tables

Deepak Shaerma — Fri, 16 Jan 2026 06:10:33 GMT

hi @LeelanathRP

Open any form (one of the 400+ tables) where you can see the field.
Right-click on the field label.
Select Configure Dictionary.ServiceNow will take you directly to the sys_dictionary record.
Look at the Table field on this record.

Example: If you are on the incident form but the field lives on task, this record will show Table: Task.
Uncheck the Active box and click Update.

Result: This deactivates the field on the parent and all 400+ child tables instantly.

Happy to help! ‌‌
To help others in the community find this solution, kindly mark this response as the Correct Answer ‌‌ and Helpful‌‌.
Warm Regards,
Deepak Sharma
Community Rising Star 2025

Re: How to find a field which is inherited on hundreds of tables

Ankur Bawiskar — Fri, 16 Jan 2026 06:33:44 GMT

@LeelanathRP

Simply search that field on your main parent table and then deactivate

It will be then be gone from all child forms, lists etc

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: How to find a field which is inherited on hundreds of tables

LeelanathRP — Fri, 16 Jan 2026 06:50:30 GMT

Hi @Deepak Shaerma ,

Thank you for your response on my query but I have tried it when I select the field and right click on it is not showing the parent table it is showing the same table( Here in my case I am looking CMDB child tables so all child tables are inheritable from CMDB_CI only right but no fields are there in CMDB_CI . so, for all 400 tables no one will create them manually on all 400 tables and it's not inherited here is my biggest doubt.

Re: How to find a field which is inherited on hundreds of tables

LeelanathRP — Fri, 16 Jan 2026 06:52:23 GMT

Hi @Ankur Bawiskar,

Thank you for your response on my query but I have tried it when I select the field and right click on it is not showing the parent table it is showing the same table( Here in my case I am looking CMDB child tables so all child tables are inheritable from CMDB_CI only right but no fields are there in CMDB_CI . so, for all 400 tables(CMDB_CI_HARDWARE, Computer etc) no one will create them manually on all 400 tables and it's not inherited here is my biggest doubt.

Re: How to find a field which is inherited on hundreds of tables

ShanmugaJ — Fri, 16 Jan 2026 08:35:28 GMT

@LeelanathRP
Simply deactivate the field on the PARENT table’s Dictionary entry.