Below are the useful keyboard shortcuts for SSMS(SQL Server Management Studio). These shortcuts are reordered and grouped in such a way as to make it easier to find what you're looking for.
SSMS:
Toggle the full-screen display - Shift+Alt+Enter
Exit - Alt+F4
Query Window:
Open with current connection - Ctrl+Q
Save current - Ctrl+S
Save All - Ctrl+Shift+S
Close - Ctrl+F4
Print - Ctrl+P
Show or hide the results pane - Ctrl+R
Toggle query & results pane - F6
Move to previous active window - Ctrl+Shift+F6
Move to the next active window - Ctrl+F6
Open SQL Server Profiler - Ctrl+Alt+P
Open Object Explorer if closed - F8
Display Go To Line dialog box - Ctrl+G
Line indent: …
Increase - TAB
Decrease - Shift+TAB
Make selected text:
Upper case - Ctrl+Shift+U
Lower case - Ctrl+Shift+L
A comment - Ctrl+K, Ctrl+C
Uncommented - Ctrl+K, Ctrl + U
Specify values:
for template parameters Ctrl+Shift+M
Current Query,selected or all:
Execute - F5 (or Ctrl+E)
Parse - Ctrl+F5
Display estimated execution plan - Ctrl+L
Cancel the executing query - Alt+Break
Output results:
in a grid - Ctrl+D
in text format - Ctrl+T
to a file - Ctrl+Shift+F
Scroll text:
up one line - Ctrl+Up-arrow
down one line - Ctrl+Down-arrow
Undo:
the last editing action Ctrl+Z
Redo:
the last undone edit - Ctrl+Y
Insert a blank line:
above the cursor - Ctrl+Enter
below the cursor - Ctrl+Shift+Enter
Delete:
all text in the window - Ctrl+Shift+DEL
the word to the right of the cursor - Ctrl+Delete
the word to the left of the cursor - Ctrl+BACKSPACE
Move the cursor:
to the beginning of the line - Home
to the end of the line - End
the beginning of the document - Ctrl+Home
to the end of the document - Ctrl+End
Move the cursor up one screen - Page Up
Move the cursor down one screen - Page Down
one word to the right - Ctrl+Right-arrow
one word to the left - Ctrl+Left-arrow
Select text from the cursor:
to the beginning of the document - Ctrl+Shift+Home
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
down line by line - Shift+Down-arrow
up line by line - Shift+Up-arrow
Select:
the entire current document - Ctrl+A
the word containing the cursor, or the closest word - Ctrl+W
the current location in the editor,back to the previous location in the editor - Ctrl+=
Extend selection:
to the top of the current window - Ctrl+Shift+Page Up
one word to the right - Ctrl+Shift+Right-arrow
one word to the left - Ctrl+Shift+Left-arrow
one page up - Shift+Page Up
one page down - Shift+Page Down
Move the cursor,extending the selection:
to the right one word - Ctrl+Shift+Alt+Rightarrow
to the left one word - Ctrl+Shift+Alt+Leftarrow
to the last line in view Ctrl+Shift+Page Down
up one line - Shift+Alt+Up-arrow
down one line - Shift+Alt+Down-arrow
Block (column-wise) - left Alt+Shift +Left-arrow
Block right - Alt+Shift +Right-arrow
Block up - Alt +Shift +Up-arrow
Block down - Alt+Shift +Down-arrow
Search for text:
Display the Find dialog box - Ctrl+F
Display the Replace dialog box - Ctrl+H
the next occurrence of the previous search text - F3
the previous occurrence of the search text - Shift+F3
the next occurrence of the currently selected text - Ctrl+F3
the previous occurrence of the currently selected text - Ctrl+Shift+F3
SQL Prompt:
Show suggestions box - Ctrl + Space
Switch to/from column picker - Ctrl + F, Ctrl + G
Move up/down the suggestions box filters - Ctrl + H, Ctrl + I
Apply format - Ctrl + K, Y
Script object as - ALTER F12
Refresh Suggestions - Ctrl + Shift + D
Intellisense:
List members - Ctrl +Space or Ctrl+J
Complete word - Alt + Right Arrow
Parameter Information - Ctrl + Shift + Space
Refresh Local Cache Ctrl + Shift + R
Jump between syntax pairs - CTRL+]
Bookmark:
go to Next one - Ctrl+K, Ctrl+N,
go to previous one - Ctrl+K, Ctrl+P
Toggle (set or remove) - Ctrl+K, Ctrl+K
Clear Bookmarks - Ctrl+K, Ctrl+H
0 comments:
Post a Comment