'What is the keyboard method for filtering in SQL Management Studio?
I make very heavy use of filtering in SQL Server Management Studio when working with a large number of stored procedures - but find it a slow process as I have to right click, move my mouse to select 'filter', type in filter, and then click OK.
Is there hotkey to pull up the filter dialog when I have the node I want to filter selected?
Thank you!
Solution 1:[1]
This is a really interesting question. I never use Filter precisely for the reason you mention.
There seem to be a lot of hotkeys for SSMS, but none for Object Explorer. Using Tools - Customize, custom hotkeys can be set for nearly every action except those of Object Explorer. There exists an Object Explorer Detail View, which you'd expect to have more features, but even that doesn't support easy shortcuts.
Triple bummer.
Rummaging around on the Internet, I happened upon a cool addin by Joseph Cooney called QuickFind, which docks near your object explorer window and accepts queries. The queried results can be clicked and the corresponding node in Object Explorer is opened. Not quite the same as a filtered view, but pretty nice nonetheless.
Apparently someone took Joseph's code and improved upon it, which led to DB Object QuickFind which I haven't tested. I think it has roughly the same functionality.
Good luck, and thanks for starting me off on my own search!
Solution 2:[2]
Yes. With the node/object selected, press the Menu key, or press SHIFT + F10 to open the context menu.
These shortcuts mimic the right click of a mouse.
Node selected:
Menu key:
Context menu:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | littlegreen |
| Solution 2 | karel |