Delete applications with contents

Question

Hi team, 
 
 We're struggling the the disk usage of our training environment as it's reaching its full capacity, there are several applications that can be deleted completely. However, there's no bulk deletion of applications including its contents, out-of-the-box. 
 
 Do you know any easier way to perform these deletions? 
 
 P.D.: We would like to delete the DB objects (tables, views, etc) related to these applications as well. 
 
 Thank you in advance! 
 Regards, 
 Tom&aacute;s

Harsh Kumar Agarwal · Answer

You can try using the Delete Folder Contents smart service for objects stored in a folder. You will still need to manually delete a few objects such as CDTs and Records , but this approach will reduce the overall time required. 
 Tables and views are easier to handle if you run a SQL query to identify objects containing your keywords, and then delete the corresponding tables and views in bulk. for example: select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%LOG%' order by TABLE_NAME 
 Hope that helps.

Shubham Aware · Answer

We initially tried multiple automated/scripted approaches, but after spending considerable time we realized manual deletion per application would have been faster and given us better control over exactly what gets deleted.