Forgive me if this is the wrong exchange site for this question. It seems like the right one.
I have been a fan of writing queries manually for a long time, but recently I've got into the habit of using the query designer in Management Studio for one reason - it allows editing of data in-place. (There's probably a way of doing this in the manual query window but I haven't found out yet)
Anyway, today I wanted to create a new instance of it for a table, and preserve the one I already had open. It wouldn't let me. When I clicked 'open table' on the object explorer it just took me to the window I already had open. This meant that if I want to query the data in a different way I have to abandon the query I had set up.
Is there a way of getting a second (or more) query designer window for the same table?
It occurs to me that I can just open a second instance of the entire app (SSMS) but that seems overkill for what must be a simple/common need.