Better way to browse MS SQL database? (T-SQL)

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?
deleydAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
I use SSMS SQL Server Management Studio.  Here's one version:  https://www.microsoft.com/en-us/download/details.aspx?id=7593
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm not aware that something like that exists but who knows?
SSMS has intellisense and that can help writing queries, since it shows you a list of tables within the database/schema and then the possible columns in a table. At least you won't write wrong column names :)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.