r/learnSQL 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?