SSMS Shortcut Keys

What is your favourite shortcut key for SSMS?

One shortcut per answer please

asked Oct 15 '09 at 09:03 AM in Default

thatismatt ♦♦
210 ● 7 ● 8 ● 9

Excellent question.

Nov 04 '09 at 09:31 AM John Sansom

(comments are locked)

24 answers:

Ctrl + R to close the results window

answered Oct 15 '09 at 09:12 AM

Jay Bonk
1.4k ● 2

That's probably my favorite at the moment. For large result sets, I'll make the result pane fill 90% of the window and then toggle it with CTRL-R.

Nov 06 '09 at 01:28 AM Tom Staab

(comments are locked)

The one I use the most is F8, to open the Object Explorer. I think it should be modified so that if it opens in "pinned" mode, pressing F8 again will close it.

answered Oct 15 '09 at 11:01 AM

Jesse McLain
106

(comments are locked)

At the end of the day I love ALT F4

answered Oct 17 '09 at 06:37 PM

Raj More
1.7k ● 74 ● 78 ● 82

(comments are locked)

CTRL + E to execute procedures.

answered Oct 15 '09 at 09:28 AM

Grant Fritchey ♦♦
62.4k ● 12 ● 20 ● 66

(comments are locked)

OK I know the question said SSMS, but EM + QA was the 'old' SSMS!

Prior to SQL2005 CTRL + B would grab focus of the divide line between query editor window and results window, and you could move it up and down with cursor keys. Still miss it!

answered Oct 15 '09 at 09:49 AM