Most commonly used Key Board Shortcuts in SQL Server Management Studio

Posted: 20/09/2015 in Tips and Tricks
Tags: ,

How familiar you are with SQL, the question always answered by how fast you work with SQL. The speed is directly proportional to the shortcuts we use. Let us discuss some useful keyboard short cuts that help you in daily activities with SSMS.

  1. Ctrl + N – New Query Window
  2. Ctrl + K  + C/U – Comment the selected line(C)/Uncomment(U)
  3. Ctrl + Shift+L/U – Make a selected word upper(U)/Lowe(L) Case
  4. Ctrl + W  – Select current ( Ctrl + Shift+ ->(arrow) )
  5. Ctrl + U – Select Database
  6. Ctrl+F5 – Parse Query
  7. Ctrl + E – Execute (F5)
  8. Ctrl + (Arrow) – Cursor move to arrow direction till next special character
  9. Ctrl + (Space)/J (Alt+Right Arrow) – List member (intellisense)
  10. Ctrl + M – Enable Execution Plan
  11. Ctrl + L – Display actual execution plan
  12. Ctrl+Shift+V – Cyclic clip board ( Paste number of copied values)
  13. F8 – Object Explorer
  14. Ctrl+Alt+T – Template Explorer
  15. Ctrl+Tab – Move between SSMS query window tabs
  16. Ctrl + D/T – Changes result type [ Grdi(D), Text(T)]
  17. Ctrl + Q – Query Designer
  18. Ctrl + R – Hide/unhide Result pane
  19. Ctrl + H – Find and replace ( Ctrl+Shift+H – > You can experiment in your system)
  20. Ctrl + Shift+T – Toggle Words both sides of a special character
  21. Ctrl + F4 – Close currently opened query window
  22. Ctrl +\ + E – Error List
  23. F10 – Step over ( Debugging shortcut)
  24. F11 – Step Into ( Debugging shortcut)
  25. F9 – Toggle Bookmark.

And also SQL supports all windows shortcuts like Ctrl+C,Ctrl+N etc.

Apart from these plenty of shortcuts, Microsoft has provided an option to customize your own shortcuts.


In “Tools” menu “Options” tab “Keyboard” -> “Query Shortcuts“, here you could set your own keyboard shortcuts. For example if you wanted select 100 rows from a table, you can set any key combinations as “Select top 100 * from ” and then select any table name in query window and press the assigned key combination to get the result. Same way you can set frequently using key words as shortcuts.

Please do start playing with SSMS and find more shortcuts and leave them in comment box.


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s