I have access to an MS SQL Server DB and I'm able to run queries on the databases.
But the since the database is too big, with multiple tables and each table having many columns (whose names aren't descriptive), I don't know which data is where.
I assumed I could use
Wireshark to listen to the port and learn from the backend about data in the DB (I have access to the frontend and the DB). But SQL server data traffic is encrypted. So I downloaded Microsoft Tools like
Microsoft SQL server manager and
Microsoft Message Analyzer and starting out.
Are there ways to figure out "which data is where" in a DB?
What must be my approach to understand the database?