SSMS Shortcut Keys

What is your favourite shortcut key for SSMS?

One shortcut per answer please

more ▼

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

thatismatt gravatar image

thatismatt ♦♦
210 7 8 9

Excellent question.
Nov 04 '09 at 09:31 AM John Sansom
(comments are locked)
10|1200 characters needed characters left

24 answers: sort voted first

I like

Ctrl + K + U - to uncomment the code

more ▼

answered Nov 03 '09 at 03:56 PM

anishmarokey gravatar image


(comments are locked)
10|1200 characters needed characters left

Books Online Index


more ▼

answered Nov 03 '09 at 09:51 PM

Mansour Shoari gravatar image

Mansour Shoari
435 13 14 15

(comments are locked)
10|1200 characters needed characters left

Running out of real estate in your code window? Give it the full screen to play with (well, almost all of it...)


(The same again to return to "normal")

more ▼

answered Jun 09 '10 at 06:21 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.3k 13 20 44

Oh, bother. My response here didn't survive the migration in one piece. And when I click on edit I get an error page.

So... the answer should be "ALT" + "SHIFT" + "RETURN". (I had wrapped it in the keyboard tag to make it look like yer actual keys...)
Jun 27 '10 at 01:17 AM ThomasRushton ♦
Looks like something is really broken in update as I cant efit your answer to format it withour a Huuuuuge stack trace and it harping on about django. +1 for this tip though. not my favoutite but its very useful when the TSQL gets large
Jun 27 '10 at 02:08 AM Fatherjack ♦♦
Glad to see it's not just me. Now all we have to do is let The Powers That Be know (which I assume you can do, given your mighty ranking)...
Jun 27 '10 at 03:12 AM ThomasRushton ♦
Not sure about my 'Mighty Ranking', but I sure can whinge well. Hay Presto - Fixed!
Jun 27 '10 at 09:37 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
One of my favourites is CTRL + SHIFT + R to refresh the Intellisense
more ▼

answered Jun 28 '10 at 09:14 AM

Håkan Winther gravatar image

Håkan Winther
15.5k 33 37 48

very useful, I didnt know you could refresh this! Thanks!
Apr 18 '11 at 10:44 AM Slick84
(comments are locked)
10|1200 characters needed characters left
CTRL+U--->to locate the pointer to databases drop down list..
more ▼

answered Mar 16 '11 at 02:08 AM

Manikreddy gravatar image

414 24 26 28

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 15 '09 at 09:03 AM

Seen: 5421 times

Last Updated: Mar 12 '12 at 12:26 AM