SQL Server Management Studio Shortcuts
Here’s
a list of shortcuts available from SQL Server Management Studio
(SSMS). This includes the function keys and what it does in SQL Server
Management Studio. Some of these shortcuts are the same as the ones
used in other applications such Microsoft Word like the ones in the
Basic Editing Shortcuts.
Basic Editing Shortcuts
Ctrl+X
|
Cut
|
Ctrl+C
|
Copy
|
Ctrl+V
|
Paste
|
Ctrl+A
|
Select All
|
Ctrl+Z
|
Undo
|
Ctrl+Y
|
Redo
|
Ctrl+F
|
Quick Find
|
Ctrl+H
|
Quick Replace
|
Ctrl+Shift+H
|
Replace in Files
|
Ctrl+G
|
Go To Line
|
File Shortcuts
Ctrl+N
|
New Query with Current Connection
|
Ctrl+Shift+N
|
New Project
|
Ctrl+O
|
Open File
|
Ctrl+Shift+O
|
Open Project/Solution
|
Ctrl+S
|
Save
|
Ctrl+Shift+S
|
Save All
|
Ctrl+P
|
Print
|
View Shortcuts
Ctrl+Alt+G
|
Registered Servers
|
Ctrl+Alt+T
|
Template Explorer
|
Ctrl+Alt+L
|
Solution Explorer
|
Ctrl+K, Ctrl+W
|
Bookmark Window
|
Ctrl+Alt+X
|
Toolbox
|
Ctrl+\, Ctrl+E
|
Error List
|
Ctrl+Alt+R
|
Web Browser
|
Ctrl+Alt+K
|
Task List
|
Ctrl+Alt+O
|
Output
|
Shift+Alt+Enter
|
Full Screen
|
Ctrl+-
|
Navigate Backward
|
Query Shortcuts
Ctrl+Shift+M
|
Specify Values for Template Parameters
|
Ctrl+L
|
Display Estimated Execution Plan
|
Ctrl+Alt+P
|
Trace Query in SQL Server Profiler
|
Ctrl+Shift+Q
|
Design Query in Editor
|
Ctrl+M
|
Include Actual Execution Plan
|
Shift+Alt_S
|
Include Client Statistics
|
Ctrl+T
|
Results to Text
|
Ctrl+D
|
Results to Grid
|
Ctrl+Shift+F
|
Results to File
|
Window Shortcuts
Ctrl+R
|
Hide/Show Results Pane
|
|
Advanced Editing Shortcuts
Ctrl+Shift+U
|
Make Uppercase
|
Ctrl+Shift+L
|
Make Lowercase
|
Ctrl+K, Ctrl+\
|
Delete Horizontal White Space
|
Ctrl+I
|
Incremental Search
|
Ctrl+K, Ctrl+C
|
Comment Selection
|
Ctrl+K, Ctrl+U
|
Uncomment Selection
|
Bookmarks Shortcuts
Ctrl+K, Ctrl+K
|
Toggle Bookmark
|
Ctrl+K, Ctrl+P
|
Previous Bookmark
|
Ctrl+K, Ctrl+N
|
Next Bookmark
|
Ctrl+K, Ctrl+L
|
Clear Bookmarks
|
Ctrl+Shift+K, Ctrl+Shift+P
|
Previous Bookmark in Folder
|
Ctrl+Shift+K, Ctrl+Shift+N
|
Next Bookmark in Folder
|
Function Keys
F1
|
Help
|
Ctrl+F1
|
Help – How Do I
|
Ctrl+Alt+F1
|
Help Contents
|
Ctrl+Alt+F2
|
Help Index
|
F3
|
Find Next
|
Ctrl+Alt+F3
|
Help Search
|
F4
|
View Properties Window
|
F5
|
Refresh / Execute
|
Alt-F5
|
Start Debugging
|
Ctrl+F5
|
Parse
|
Ctrl+Alt+F5
|
Help Tutorial
|
F6
|
Window-Next Pane
|
Shift+F6
|
Window-Previous Pane
|
F7
|
View Object Explorer Details
|
F8
|
View Object Explorer
|
Alt+F8
|
Open Server in Object Explorer
|
F9
|
Debug-Toggle Break Point
|
F10
|
Debug-Step Over
|
F11
|
Debug-Step Into
|
Intellisense Shortcuts
Ctrl+J
|
List Members
|
Ctrl+Shift+Space
|
Parameter Info
|
Ctrl+K, Ctrl+I
|
Quick Info
|
Alt+Right Arrow
|
Complete Word
|
Ctrl+Shift+R
|
Refresh Local Cache |
|
No comments:
Post a Comment