how can we delete the related list data and table

mastanbe
Tera Contributor

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.

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

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

AGLearnNGrow_0-1743612055776.png

 

*************************************************************************************************************
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]

****************************************************************************************************************

jMarshal
Mega Sage
Mega Sage

@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.

 

jMarshal_0-1743612416833.png

(sc_task table, for example)

jMarshal_1-1743612486632.png

(removing Approvers related list, for instance)

jMarshal_2-1743612578873.png



...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!

Robert H
Mega Sage

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.

RobertH_0-1743612579065.png

 

Regards,

Robert

 

Shivalika
Mega Sage

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