Top SQL Server Management Studio (SSMS) Shortcut keys

• blndazeez

  Valued Member

  Points: 57

  More actions

  June 22, 2018 at 12:35 pm

  #352171

  Working with the keyboard is a lot faster and more productive, in this video, I am going to show you my favorite 22 shortcut keys for SQL Server Management Studio (SSMS).

  Basics
  -----------
  Ctrl + N  => New Query
  Alt + F4  => Close Window
  Alt   => Main Menu
  Shift + F10 => Context Menu
  Alt + Tab  => Navigat to other window/tool window
  F5  => Execute current Query
  Alt + Break => Cancel or Stop current running query
  Ctrl + J  => List Members (Intelesense)
  Shift + Alt + Enter  => Enter/Exit Full screen mode
  Shift + ESC  => Close current tool window

  Bookmars
  ----------------
  Ctrl + K, Ctrl + K  => Add/Remove bookmark
  Ctrl + K, Ctrl + N  => Next bookmark
  Ctrl + K, Ctrl + P  => Prev bookmark
  Ctrl + K, Ctrl + L  => Clear all bookmarks

  Debuggin
  -----------------
  Alt + F5   => Start/Continue debugging
  Shift F5   => Stop debugging
  F11  => Step into
  F10  => Step over
  Shift + F11 => Step out
  Ctrl + Alt + Q => QuickWatch

  Break Points
  -----------------
  F9   => Toggle breakpoint
  Ctrl + F9  => Enable Breakpoint
  Ctrl + Shift + F9  => Remove all breakpoints
  Ctrl + Alt + B  => BreakPoint Window

  Tools Window
  -----------------
  F8   => Object Expolorer
  F4   => Property Window
  Ctrl + Alt + A  => Activity monitor
  Ctrl + Alt + W, 1 => Display the Watch1 window
  Ctrl + Alt + W, 2 => Display the Watch2 window
  Ctrl + Alt + W, 3 => Display the Watch3 window
  Ctrl + Alt + W, 4 => Display the Watch4 window
  Ctrl + Alt + V, L => Display the Locals Window

  Misc.
  -----------------
  Ctrl + Alt + I => Display the Immediate Window
  Ctrl + 1   => sp_who
  Ctrl + 2   => sp_lock
  https://www.youtube.com/watch?v=-IErbVHGvcU
  [YouTube]https://www.youtube.com/watch?v=-IErbVHGvcU[/YouTube]