how can we delete the related list data and table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā04-02-2025 09:36 AM
Hi
how can we delete the related list data and table and how can we remove and delete the related list section.
could you please step by step process.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā04-02-2025 09:41 AM
Hi @mastanbe
Table deletion? Is there any reason for it? Are you running it in your PDI or in the customer instance? Deleting a table may impact many areas if itās used in flows or logic, so think carefully before proceeding.
To delete a table and its data, ensure you're fully aware of the consequences and dependencies before executing it.
Go to sys_db_object table
open the table
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā04-02-2025 09:43 AM - edited ā04-02-2025 09:51 AM
@mastanbe - I am assuming that you want to remove the specific related list(s) from the form view for any given table, not delete the related table itself & all data therein...
Just go to your filter navigator ("All") and search/filter for "table_name.do" and on the resulting page, right click any of the header and select "configure" > "related lists" then remove the ones that you do not want to have visible on the form.
(sc_task table, for example)
(removing Approvers related list, for instance)
...now, if you're actually looking to also delete the table and all of it's data, @Dr Atul G- LNG Atul's got you covered!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā04-02-2025 09:51 AM
Hello @mastanbe ,
I doubt that you want to actually delete a table. Please provide a screen shot to help us understand your requirement.
If you just want to remove a Related List from a form then you can use "Configure Related Lists" from the context menu of that form.
Regards,
Robert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā04-02-2025 11:26 AM
Hello @mastanbe
Instead of going by deletion create an "Archive rule" on the table with your required conditions and the related list will automatically be deleted along with records.
If you click on "Delete Records" in sys_db_object table configuration - it will delete 1000 records from the table.
Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.
Regards,
Shivalika
My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194
My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY