SSMS: The Query Window Keyboard Shortcuts.
This wall-chart gives, on a single page,
quicker and easier. This is intended to help ordinary mortals who find the assignment of the keystrokes unintuitive
all the more useful keyboard
shortcuts that make the editing of SQL queries
and difficult to
visibility of the results pane. The latest version of this wall-chart will be held on Simple-Talk
remember. Sometimes there is no GUI equivalent,
as with
the block selection of text or
…Toggle the full-screen display
Shift+Alt+Enter
SSMS
…down line by line
Shift+Down-arrow
…Exit
Alt+F4
… up line by line
… the entire current document
Open
with current connection
Ctrl+Q
Query Window
Select
the word containing the cursor, or
Ctrl+W
…
back to the previous location in the
the current location in
the editor,
Ctrl+=
…Close
Ctrl+F4
editor
…Print
…Show or hide the results pane
Extend selection
…to the top of the current window
Ctrl+Shift+Page
Up
…
one word to the right
Ctrl+Shift+Right-arrow
…Toggle query
& results pane
F6
… one word to the left
Ctrl+Shift+Left-arrow
…Move to
previous
active window
Ctrl+Shift+F6
… one page
up
…Move to the next active window
…Open SQL Server Profiler
… one page
down
Move the cursor,
extending the
…To the right one word,
Ctrl+Shift+Alt+Right-
arrow
…Open Object Explorer if closed
F8
…Display Go To Line
dialog box
Ctrl+G
selection
line indent
… to the left one word,
Ctrl+Shift+Alt+Left-
arrow
… to the last line in view,
Ctrl+Shift+Page
Down
…upper case
Ctrl+Shift+U
Make
selected text
…
up one line
Shift+Alt+Up-arrow
…lower case
Ctrl+Shift+L
…down
one line
Shift+Alt+Down-arrow
Ctrl+K, Ctrl+C
Ctrl+K, Ctrl
…Block (column-wise) left
…Block right
+ U
…for template parameters
Ctrl+Shift+M
Specify values
…Block up
Alt
+Shift
+Up-arrow
…Execute
F5
(or Ctrl+E)
Current Query,
selected or all
…Block down
Alt+Shift
+Down-arrow
…Parse
Ctrl+F5
Search for text
…Display the Find
dialog box
Ctrl+F
…Display
…Cancel the executing query
estimated execution plan
…Display the Replace
dialog box
Ctrl+H
the next occurrence of the
F3
…in a grid
Ctrl+D
Output results
the previous occurrence of the
Shift+F3
…in text format
…to a file
…the next occurrence of the
currently
Ctrl+F3
…
up one line
Ctrl+Up-arrow
selected text
the previous occurrence of the
Scroll text
…
currently selected text
Ctrl+Shift+F3
…
down one line
Ctrl+Down-arrow
… the last editing action
… the last
SQL Prompt
…Show suggestions box
Ctrl + Space
undone edit
…Switch to/from column picker
Ctrl + F, Ctrl + G
…above the cursor
Ctrl+Enter
Insert a blank line
…Move up/down the suggestions
box filters
Ctrl + H, Ctrl + I
…
below the cursor
Ctrl+Shift+Enter
…all text in the window
…the word to the right of the cursor
Ctrl+Shift+DEL
Ctrl+Delete
Delete
…Apply format
Ctrl + K, Y
…Script object as ALTER
F12
…the word to the left of the cursor
Ctrl+BACKSPACE
…Refresh Suggestions
Ctrl
+ Shift + D
…to the beginning of the line
Home
Move the cursor
Intellisense
…List members
…Complete word
Ctrl +Space
Alt + Right Arrow
or
Ctrl+J
…to the end of the line
…the beginning of the document
…to the end of the document
Ctrl+End
…
Parameter Information
Ctrl + Shift + Space
…Move the cursor up one screen
Page
Up
…
Refresh Local Cache
Ctrl + Shift + R
…Move the cursor down one screen
Page
Down
CTRL+]
…
Jump between syntax pairs
…one word to the right
…one word to the left
…to the beginning of the document
Ctrl+Right-arrow
Ctrl+Left-arrow
Ctrl+Shift+Home
Bookmark
…go to Next
…go to previous one
one
Ctrl+P
Select text from
the cursor
…Toggle (set or remove)
Ctrl+K, Ctrl+K
…
Clear Bookmarks
Ctrl+K, Ctrl+H
… to the end of the document
Ctrl+Shift+End
…to the start of the current line
Shift+Home
…to the end of the current line
Shift+End
All Rights reserved Simple-Talk Publications