Mapping keyboard shortcuts in SSMS
To map keyboard shortcuts1):
- Tools → Options
- Environment → Keyboard
- For each shortcut:
- In the scroll pane containing the list of commands, select (click to highlight) the command for which you want to create a shortcut. You can type in command fragments in the box above the pane to filter the list.
- Use the 'Use new shortcut in' dropdown to choose the scope of your shortcut
- Click into the 'Press shortcut keys' field
- Press your key combination (e.g. F5, Ctrl + R, Ctrl + Alt + K)
- Click the 'Assign' button to the right of the dropdown.
- When you have finished assigning shortcuts, click OK.
Selected common settings
Command | Description | Key combination | Scope |
---|---|---|---|
View.Refresh | The command called from a right-click context menu's 'Refresh' item | F5 | Global |
Query.Execute | Execute a SQL query from the query editor | F5 | SQL Query Editor |
Window.ShowResultsPane | Toggle display of the results pane in the query editor | Ctrl+R | SQL Query Editor |
1)
A number of commands in SSMS 2012 seemed to be mapped differently than in previous versions, also opening an Integration Services catalog for the first time in SSMS 2014 resets a few popular options. Here's how to fix that!