Tips ‘N’ Tricks – SSMS – Easy way to Learn Keyboard Shortcuts by Enabling ScreenTips

I am a great fan of Keyboard Shortcuts and I am sure most of you like Keyboard Shortcuts too. The usual way what I have observed is that, to learn Keyboard Shortcuts, people keep a printout pinned at their desk, memorize it, keep it in a notepad, and so on. However, when it comes to SQL Server Management Studio (SSMS), there is a great feature called ScreenTips which apart from showing the name of the action in the tooltips, also allows showing the Keyboard Shortcut associated with the corresponding action. Pretty much every action like Execute, Comment, and Uncomment etc. has a Keyboard Shortcut associated with it.

Here is how you enable the feature to display the Keyboard Shortcuts in the ScreenTips in SSMS.

  • Open SSMS
  • Go to Tools | Customize…
  • In the Customize Window, ensure that Shot ScreenTips on toolbars is checked and Show shortcut keys in ScreenTips is unchecked
  • Your Customize Window should look similar to the following screenshot. Click Close.

  • Now hover your mouse over some of the common options like New Query, Execute, and Parse etc. Notice that only the name of the option/action is displayed in the Tooltip as shown below.

  • Now again go to Tools | Customize…
  • In the Customize Window, check the Show shortcut keys in ScreenTips option as shown in the below screenshot. Click Close.

Note that, to select/enable the Show shortcut keys in ScreenTips option, Show ScreenTips on toolbars option should remain selected/checked.

  • Now again hover your mouse over the same options over which you hovered your mouse in the previous steps like New Query, Execute, and Parse etc. Notice that along with the name of the option/action, the associated Keyboard Shortcut is also displayed in brackets in the Tooltip as shown in the following screenshot.

Now, whenever you perform an action in SSMS by clicking on particular option/button, you get to see the corresponding Keyboard Shortcut every time you perform that action. This way, you will easily get remember/memorize the shortcut.

In my opinion, this is one of the great but under appreciated features of SSMS. Do share your approach of learning shortcuts by leaving a comment below 🙂

Note: Tested with SSMS 2008/2008 R2.

Take a look at the other Tips and Tricks in this Series on Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on May 9, 2012, in Keyboard Shortcuts, Shortcuts, SSMS, SSMS Shortcuts, SSMS Tips, Tips 'N' Tricks and tagged , , , , , , , , , . Bookmark the permalink. 3 Comments.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: