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

[LeelanathRP]

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.

[Deepak Shaerma]

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

[LeelanathRP]

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.

[Ankur Bawiskar]

@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! 🙏

[LeelanathRP]

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.