Application Table Usage

Let’s say we’re supporting an internal application that interacts with a company database, but we don’t have access to the app’s source code. We need to figure out which database tables are being used when the app fetches data for a user with ID 12.

How would you go about identifying which tables are involved in retrieving this user’s data?