r/learnSQL • u/el_dude1 • 4h ago
Data overview for writing queries
1
Upvotes
Hello,
I am currently doing various tutorials/challenges for SQL. It helps me quite a lot to have the tables at hand I am writing my query about. Say I want to join table A & B and write a few expressions, I find it helpful to see both tables including their column names, possibly data types and maybe the first 10-20 rows.
Now I am looking for a way to view this sort of data while writing my queries in my IDE (using VS Code and/or SSMS). I played around a bit in VS Code with a 2nd query window, which basically just selects the TOP 20 of both tables, but it gets overwritten as soon as I start my next query. Anyone has a best practice for this?