SQL Complete shortcut keys

Last modified: October 28, 2024

Use the following shortcut keys when working with SQL Complete.

Command name	Shortcut keys	Action	Where is used
Code completion
Enable/disable	Ctrl+Shift+D	Enable/disable code completion	SQL document
Execute Current Statement	Ctrl+K,E	Execute current statement	SQL document
Execute to Cursor	Ctrl+F10	Execute the script to cursor	SQL document
Go to Definition	F12	Go to an object in Object Explorer	SQL document
Jump Between Syntax Pairs (BEGIN/END, BEGIN TRY/END TRY, BEGIN CATCH/END CATCH, CASE/END)	Shift+F12	Navigate between paired syntactic constructions	SQL document
Insert Semicolons	Ctrl+B,C	Insert ; in a document	SQL document
Wildcard expansion	Tab	Expand the asterisk symbol to the list of all of the columns that exist in tables, views, and table-valued functions in the SELECT FROM statement	SQL document
INSERT, EXEC, ALTER and UPDATE statements expansion	Tab	Expand the INSERT, EXEC, ALTER, and UPDATE statements to a full code template	SQL document
Rename (objects, aliases and variables)	F2	Rename objects, aliases, and variabled declared in a script	SQL document
Format Document	Ctrl+K,D	Format en entire document	SQL document
Format Selection	Ctrl+K,F	Format a highlighted area	SQL document
Script Object as CREATE/ALTER	Ctrl+F12	Generate DDL object	SQL document
Complete Word	Ctrl+Space/ALT+Right Arrow	Complete a word	SQL document
Parameter Info	Ctrl+Shift+Space	Display parameter information	SQL document
Quick Info	Ctrl+K, I	Display quick information	SQL document
Statement Navigation (next statement)	Alt+PgDn	Statements navigation (down)	SQL document
Statement Navigation (previous statement)	Alt+PgUp	Statements navigation (up)	SQL document
Navigation between COLUMNS and VALUES in the INSERT statement	Shift+F12	Quickly locate the corresponding value for the current column	SQL document
Suggestions semi-transparent	Ctrl	Semi-transparent completion list	SQL document
Move through the list of suggestions	Page Up	Move one page up	Completion list
Move through the list of suggestions	Page Down	Move one page down	Completion list
Move through the list of suggestions	Ctrl+Page Up	Move to the top of the list	Completion list
Move through the list of suggestions	Ctrl+Page Down	Move to the bottom of the list	Completion list
Select elements from the list using Column Picker	Space/Insert/Enter/Tab	Select columns using Column Picker	Completion list (Column Picker)
Select an element from the list (commit selection)	Enter	Insert an element to a SQL document from the completion list (set by default)	Completion list
Select an element from the list (commit selection)	Tab/Space/Any symbol	Insert an element to a SQL document from the completion list (set by default, determined by settings)	Completion list
Navigate the tags of the inserted snippet (forward)	Tab	Navigate through highlighted fragments of snippet parameters in a SQL document in data entry mode	SQL document (inserted snippet)
Navigate the tags of the inserted snippet (backward)	Shift+Tab	Navigate through highlighted fragments of snippet parameters in a SQL document in data entry mode	SQL document (inserted snippet)
Exit the insert mode of snippet parameters	Esc/Enter	Exit the parameter input mode in a snippet	SQL document (inserted snippet)
Navigate fields in the snippet editor (forward)	Tab	Navigate the cursor across fields in the snippet editor	Snippets Manager
Navigate fields in the snippet editor (backward)	Tab	Navigate the cursor across fields in the snippet editor	Snippets Manager
Productivity
Query History	Ctrl+Alt+H	Open SQL History dialog	SSMS
Show Data Viewer	Ctrl+Alt+D	Open Data Viewer	SSMS
Restore Last Closed Document	Alt+Z	Restore the tab of a previously closed document	SSMS Tab
Find Invalid Objects	Ctrl+Alt+F	Open “Find Invalid Objects”	SSMS
Result Grid
Find in Result Grid	Shift+Alt+F	Open the search window in Result Grid	Result Grid
Generate Script As (INSERT) to Clipboard	Ctrl+J,I	Copy a generated scirpt to clipboard	Result Grid
Generate Script As (INSERT #tmpTable) to Clipboard	Ctrl+J,T	Copy a generated scirpt to clipboard	Result Grid
Generate Script As (WHERE IN()) to Clipboard	Ctrl+J,W	Copy a generated scirpt to clipboard	Result Grid
Generate Script As (WHERE AND OR) to Clipboard	Ctrl+J,O	Copy a generated scirpt to clipboard	Result Grid
Generate Script As (UPDATE) to Clipboard	Ctrl+J,U	Copy a generated scirpt to clipboard	Result Grid
Copy Data As (Copy Column Names Only)	Ctrl+Alt+Y,N	Copy data to clipboard	Result Grid
Copy Data As (Copy Column Names and Types)	Ctrl+Alt+Y,T	Copy data to clipboard	Result Grid
Copy Data As (CSV) To Clipboard	Ctrl+Alt+Y,C	Copy data to clipboard in CSV format	Result Grid
Copy Data As (XML) To Clipboard	Ctrl+Alt+Y,X	Copy data to clipboard in XML format	Result Grid
Copy Data As (HTML) To Clipboard	Ctrl+Alt+Y,H	Copy data to clipboard in HTML format	Result Grid
Copy Data As (JSON) To Clipboard	Ctrl+Alt+Y,J	Copy data to clipboard in JSON format	Result Grid
Select a value from the Aggregate panel	Ctrl+A	Highlight a value in the Aggregate panel	Result Grid (Aggregate panel)
Copy a value from the Aggregate panel	Ctrl+C	Copy a value from the Aggregate panel	Result Grid (Aggregate panel)
Debugger
Breakpoints	Ctrl+Alt+B	Open the Breakpoints pane	Global
Call Stack	Ctrl+Alt+C	Open the Call Stack pane	Global (when a debug session is started
Watches	Ctrl+Alt+W	Open the Watches pane	Global (when a debug session is started)
Delete All Breakpoints	Ctrl+Shift+F9	Delete all breakpoints	Global (when debug session is started)
Toggle Breakpoint	F9	Enable or disable a breakpoint depending on its current state	SQL document
Start/Continue	Alt+F5	Start/continue debugging	SQL document
Stop Debugging	Shift+F5	Stop debugging	Global (when a debug session is started)
Restart	Ctrl+Shift+F5	Restart debugging	Global (when a debug session is started)
Step Into	F11	Step into the next statement	SQL document
Step Over	F10	Step over next statement	SQL document
Step Out	Shift+F11	Step out of a stored procedure, function, or trigger	Global (when a debug session is started)