Ten Favorite Keyboard Shortcuts in SQL Server Management Studio

Monday Jun 28th 2021 by Gregory A. Larsen

Every mouse click or menu choice takes your hands away from the keyboard, and slows down your work.  Use these 10 keyboard shortcuts to make your workflow fly.

If SQL Server Management Studio is your primary tool for writing your TSQL, then you need to learn keyboard shortcuts to be more efficient. 

Keyboard shortcuts are a combination of one or more keys that when entered together perform some task, that would normally take a mouse click, or multiple commands to accomplish.   There are many different types of categories of keyboard short cuts, toolbar, menu, window management and cursor movement to name a few.

  1. F5 – Executes TSQL script 
  2. CTRL+N – Opens a new query window using the existing connection
  3. CTRL+K+C – Comments out a set of lines highlighted 
  4. CTRL+K+U – Uncomments a set of lines highlighted 
  5. CTRL+SHIFT+U – Converts highlighted characters to upper case
  6. CTRL+SHIFT+L – Converts highlighted characters to lower case
  7. CTRL+F – Brings up the search window
  8. CTRL-HOME –Repositions the cursor at beginning document
  9. CTRL-END – Reposition the cursor to end of document
  10. CTRL+G – Allows you to jump to a specific line in a script

These is are my 10 favorite, most-used shortcuts.  If you’d like to see all of the keyboard shortcuts, you can find them here.

Mobile Site | Full Site