I would like to know if there is a way to pull list of all tables where specific case ID(s) is/are stored. So that if i have to delete a Case ID, i will have a definite list of tables were i can delete.
So far i have collected these tables, but i guess there will be more. Is there a definite list of tables where i should be looking at.
List of tables which store case ids , can keep vary with application design.
To get the complete list of tables you can consider checking all the tables associated with work, assign and index classes using DesignStudio > Data Model > Classes and Properties > Database Class Mappings option in designer studio.
This would give the complete list of tables associated with each class type and then you quickly do the query of tables (in doubt) to verify the data.
While above list of yours shares the basic and standard tables, you may also need to include tables related to Index classes.