Currently when we want to browse our database to figure out why a certain something didn't show up on a report, we start writing SELECT statements to see what's in the database.
This seems like a very slow and inefficient way to check out what data we have in the database. Is there a better way?
I imagine a program which displays a table row, once I find the table and row I'm interested in, and then for the Foreign Key column I just double-click on the value to instantly hyperlink to whatever it's pointing to — rather than writing down the value on a slip of paper and then typing in another SELECT statement to find out where that leads us to (and then fixing the syntax of that SELECT statement until it actually works).
Slightly fancier would be showing me what other tables have a Foreign Key pointing to the Primary Key of this table, and with one click it will show me the relevant rows in those other tables.
It just seems by now someone would have written a program that makes browsing a SQL database much easier than writing SELECT statements and executing them. Is there such a program?