I'm looking for database solutions or applications that can help me visualize which columns are affected by certain functions, based on a database schema. The challenge is that I'm currently working with a database that I didn't create, and it's tough to figure out which columns are utilized for different functions or in reports. Does anyone know of tools or methods that can assist with this?
1 Answer
Unfortunately, it seems like such a tool doesn't currently exist. We've been on the lookout for something like this for over ten years to manage a large database with connections to over 250 applications. It's really surprising!
Could you share what kind of applications you're dealing with? It’s hard to believe there's nothing out there, especially for documentation. I might even consider creating a solution myself.