Using keyboard shortcuts
Page last updated 15 October 2018
Published 11 February 2013
Using keyboard shortcuts to select and insert code suggestions in SQL Prompt can dramatically increase the speed of writing your SQL code. For ease of reference, the keyboard shortcuts have been grouped by functionality.
Code Completion
| Action | Shortcut |
|---|
| Refresh Suggestions | Ctrl+Shift+D |
| Toggle Suggestions On/Off | Ctrl+Shift+P |
| Show Suggestions | Ctrl+Space |
| Switch to/from column picker | Ctrl + Left arrow / Ctrl + Right arrow |
| Move up/down suggestions list | Up arrow / Down arrow |
| Move up/down the suggestions box filters | Ctrl + Up arrow / Ctrl + Down arrow |
Navigation
| Action | Shortcut |
|---|
| Summarize Script | Ctrl+B,Ctrl+S |
| Find Unused Variables and Parameters | Ctrl+B,Ctrl+F |
| Script OBJECT as ALTER | F12 |
| Select in Object Explorer (SSMS only) | Ctrl+F12 |
| Execute Current Statement | Shift+F5 |
| Execute Current Batch | Alt+Shift+F5 |
| Execute To Cursor | Ctrl+Shift+F5 |
| Action | Shortcut |
|---|
| Format SQL | Ctrl+K, Ctrl+Y |
| Apply Casing Options | Ctrl+B,Ctrl+U |
| Qualify Object Names | Ctrl+B,Ctrl+Q |
| Expand Wildcards | Ctrl+B,Ctrl+W |
| Insert Semicolons | Ctrl+B,Ctrl+C |
| Add/Remove Square Brackets | Ctrl+B,Ctrl+B |
| Inline Stored Procedure | Ctrl+B,Ctrl+I |
| Encapsulate as new stored procedure | Ctrl+B,Ctrl+E |
| Rename Scripted Object | F2 (Shift+F2 in Visual Studio) |
Code analysis
| Action | Shortcut |
|---|
| Toggle Code Analysis On/Off | Ctrl+Shift+A |
Opens issue details
(cursor must be in the green squiggling area) | Ctrl |
Miscellaneous
| Action | Shortcut |
|---|
Open action list
(some text must be selected beforehand) | Ctrl |
| Browse open tabs | Ctrl + Q |
Didn't find what you were looking for?
