How to find the number of custom tables present in the system which are unused

Shankha B
Tera Contributor

‎05-31-2024 12:39 AM

Hi Team,

I have got one requirement to find out the custom tables present in the system which are unused to save the cost of implementation. However, I am getting the count of custom tables in the system but unable to find the custom tables which are unused.

Is there any way we can do this?

Thanks in advance.

0 Helpfuls
  • 526 Views
1 REPLY 1

Sandeep Rajput
Tera Patron
Tera Patron

‎05-31-2024 01:16 AM

@Shankha B  Just by looking at the data you can figure out if the table is being used actively on the instance or not.

1. Check when was the last time a record was inserted/updated on the table?

2. Check the number of records and how many of them recently added

3. Check which roles have access to the table and to which group/user that role is assigned. Reach out to those users to know if they know about those custom tables and if they serve any purpose

4. Check the scripts BR/Script Include and see if the table is being called from any of them.

 

Hope this helps.

0 Helpfuls