Shortcut / Keyboard keys are very important role to increase the productivity. In case DBA’s are spending at least 6 hours on daily basis on SQL Server Management Studio, which is true in most of the cases, we love, if we get shortcut keys, to avoid using mouse to increase productivity
Here is list of Shortcut keys to work with SSMS handy.
| Action | SSMS-Shortcut Key |
| Move to the SQL Server Management Studio menu bar | ALT |
| Activate the menu for a tool component | ALT+HYPHEN |
| Display the context menu | SHIFT+F10 |
| Display the New File dialog box to create a file | CTRL+N |
| Display the New Project dialog box to create a new project | CTRL+SHIFT+N |
| Display the Open File dialog box to open an existing file | CTRL+O |
| Display the Open Project dialog box to open an existing project | CTRL+SHIFT+O |
| Display the Add New Item dialog box to add a new file to the current project | CTRL+SHIFT+A |
| Display the Add Existing Item dialog box to add an existing file to the current project | ALT+SHIFT+A |
| Display the Query Designer | CTRL+SHIFT+Q |
| Close a menu or dialog box, canceling the action | ESC |
| Clear all bookmarks | CTRL-SHIFT-F2 |
| Insert or remove a bookmark (toggle) | CTRL+F2 |
| Move to next bookmark | F2 |
| Move to previous bookmark | SHIFT+F2 |
| Cancel a query | ALT+BREAK |
| Connect | CTRL+O |
| Disconnect | CTRL+F4 |
| Disconnect and close child window | ALT+F4 |
| Database object information | ALT+F1 |
| Clear the active Editor pane | CTRL+SHIFT+DEL |
| Comment out code | CTRL+SHIFT+C |
| Copy | CTRL+C or Ctrl+Insert |
| Cut | CTRL+X or Shift+Del |
| Decrease indent | SHIFT+TAB |
| Delete through the end of a line in the Editor pane | CTRL+DEL |
| Find | CTRL+F |
| Go to a line number | CTRL+G |
| Increase indent | TAB |
| Make selection lowercase | CTRL+SHIFT+L |
| Make selection uppercase | CTRL+SHIFT+U |
| Paste | CTRL+V or Shift+Insert |
| Remove comments | CTRL+SHIFT+R |
| Repeat last search or find next | F3 |
| Replace | CTRL+H |
| Select all | CTRL+A |
| Undo | CTRL+Z |
| Execute a query | F5 or Ctrl + E |
| Help for Query Analyzer | F1 |
| Help for the selected Transact-SQL statement | SHIFT+F1 |
| Switch between query and result panes | F6 |
| Switch panes | Shift+F6 |
| Window Selector | CTRL+W |
| New Query window | CTRL+N |
| Object Browser (show/hide) | F8 |
| Object Search | F4 |
| Parse the query and check syntax | CTRL+F5 |
| CTRL+P | |
| Display results in grid format | CTRL+D |
| Display results in text format | CTRL+T |
| Move the splitter | CTRL+B |
| Save results to file | CTRL+SHIFT+F |
| Show Results pane (toggle) | CTRL+R |
| Save | CTRL+S |
| Insert a template | CTRL+SHIFT+INSERT |
| Replace template parameters | CTRL+SHIFT+M |
| Display estimated execution plan | CTRL+L |
| Display execution plan (toggle ON/OFF) | CTRL+K |
| Index Tuning Wizard | CTRL+I |
| Show client statistics | CTRL+SHIFT+S |
| Show server trace | CTRL+SHIFT+T |
| Use database | CTRL+U |
I am going to post another 4-5 articles, which will discuss about
- SSMS Text Selection Keyboard Shortcuts
- SSMS Bookmark Keyboard Shortcuts
- SSMS Tree Control Keyboard Shortcuts
- SSMS Code Editor Keyboard Shortcuts
- SSMS Text Manipulation in Code Editor Keyboard Shortcuts
- SSMS Microsoft IntelliSense Keyboard Shortcuts
- SSMS Document Window and Browser Keyboard Shortcuts
- SSMS Solution Explorer Keyboard Shortcuts
- SSMS Help and Books Online Keyboard Shortcuts
- SSMS Search Keyboard Shortcuts
- SSMS Cut and Paste Keyboard Shortcuts
- SSMS Log Viewer Keyboard Shortcuts
- SSMS Activity Monitor Keyboard keys
- SSMS Replication Monitor Keyboard Shortcuts
- SSMS Replication Conflict Viewer Keyboard Shortcuts
Tags : Keyboard Shortcut Keys,SSMS Shortcut Keys, SSMS Keyboard Keys, SQL Server Management Studio Keyboard Shortcut Keys,SQL Server Management Studio Shortcut Keys, SQL Server Management Studio Keyboard Keys,
Great resource but I would like to point out that SSMS 2008 now defaults to “Standard” for keyboard shortcuts. You would need to change it to SQL Server 2000 to use the above shortcuts. Source: