SSMS: Select Multiple Tables/Views/Objects

In Microsoft SQL Server Management Studio (SSMS) I've often been annoyed by the apparent inability to use my Shift or Ctrl keys to select multiple objects at once in the Object Explorer window.

I'm happy to say that there is in fact a way you can multi-select tables, views, whatever objects you like!

Go to the 'View' menu and select 'Object Explorer Details'. This glorious new pane will open and allow you to select as many objects as your heart desires. You can also just hit the F7 key as a quick shortcut. How awesome is that?

It's beyond me why this is only possible in this details pane, so if you happen to have some insight then I'd love to hear about it in a comment down below.


Post a Comment