Query Navigation and Editing:
-
-
- F5/Ctrl + E: Execute the current query.
- Ctrl + L: Clear the results pane.
- Ctrl + F5: Execute the current query and keep the results pane hidden.
- Alt + Break: Cancel a running query.
- Ctrl + G: Go to a specific line number.
- Ctrl + Shift + F: Find in all open query tabs.
- Ctrl + Shift + U/L: Uppercase/lowercase the selected text.
- Ctrl + K, Ctrl + C/U: Comment/uncomment the selected text.
- Ctrl + Shift + M: Open the Object Explorer context menu for the selected object in the query window.
-
Object Explorer and Connection Management:
-
-
- F8: Open the Object Explorer.
- F7: Toggle the Object Explorer details pane.
- Ctrl + Q: Open the Quick Launch bar.
- Ctrl + Shift + S: Save all open query tabs.
- Ctrl + D: Connect to a SQL Server instance.
- Ctrl + T: Open a new query tab.
- Ctrl + Shift + F: Find in Object Explorer.
-
Other Useful Shortcuts:
-
-
- Shift + Alt + Enter: Toggle full screen mode.
- Ctrl + P: Print the current query or results.
- Ctrl + F4: Close the current query tab or SSMS.
- Ctrl + Z/Y: Undo/Redo actions.
- Ctrl + Home/End: Go to the beginning/end of the current line.
- Ctrl + A/W: Select all/clear the current line.
- Ctrl + Shift + Page Up/Down: Scroll up/down by a page.
- Alt + F4: Close SSMS.
-