Using keyboard shortcuts
Published 29 October 2019
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 |
Formatting and Refactoring
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 | Ctrl |
Miscellaneous
Action | Shortcut |
---|---|
Open action list | Ctrl |
Browse open tabs | Ctrl + Q |