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

[Shankha B]

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.

[Sandeep Rajput]

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