Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SQL Server Management Studio keyboard shortcuts

Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW)

SQL Server Management Studio (SSMS) offers keyboard shortcuts. By default, it uses the SQL Server scheme, with keyboard shortcuts based on Visual Studio. To change the keyboard scheme or add more keyboard shortcuts, from the Tools menu, select Options. Select the desired keyboard scheme on the Environment > Keyboard page.

Menu Activation keyboard shortcuts

Action	Shortcut
Move to the SQL Server Management Studio menu bar
Activate the menu for a tool component	+
Display the context menu	+
Display the New File dialog box to create a file	++
Display the New Project dialog box to create a new project	++
Display the Open File dialog box to open an existing file	+
Display the Open Project dialog box to open an existing project	++
Display the Add New Item dialog box to add a new file to the current project	++
Display the Add Existing Item dialog box to add an existing file to the current project	++
Close a menu or dialog box, canceling the action

Windows Management and Toolbar keyboard shortcuts

Action	Shortcut
Open a new query editor window	+
Cycle through the MDI child windows	+ or ++
Cycle through the MDI child windows using the IDE navigator	+ or ++
Display a popup listing all open MDI child windows	++
Display the IDE navigator with the first tool window selected	+
Display the IDE navigator with the first MDI child window selected	+
Display the dock menu	+
Display Query Designer (avilble for the query editor)	++
Display Object Explorer
Display Object Explorer Details
Display Registered Servers	++
Display Template Explorer	++
Display Solution Explorer	++
Display Copilot in SSMS	++
Display the Properties Window
Display the Output window	++
Display the Task List window	+, or +, +
Display the Toolbox	++
Display the Bookmarks Window	+, +
Display the Browser Window	++
Display the previous page in the viewing history. Available only in the Web browser window	+
Display the next page in the viewing history. Available only in the Web browser window	+
Display the Error List Window (Transact-SQL Editor only)	+, +
Move to the next entry in the Error List window (Transact-SQL Editor only)	++
Moves the insertion point to the dropdown bar located at the top of the code editor when the editor is in Code view or Server Code view	+
Move to the current tool window toolbar	+
Move to the next tool window	+
Move to the previous tool window	++
Move to the next pane of a split pane view of a single document
Move to the previous pane of a split pane view of a single document	+
Toggle between the Query Editor and the Results Pane
Toggle between Object Explorer Details list view and Object Explorer Details property pane.
Toggle full screen mode	++
Control the splitter bar that separates the Object Explorer Details list view and Object Explorer Details property pane to adjust the size of the display pane.	, then hold the or
Close a menu or dialog box, cancel an operation in progress, or focus on the current document window
Close the current MDI child window	+
Close the current tool window	+
Exit	+
Print	+

Cursor Movement keyboard shortcuts

Action	Shortcut
Move the cursor left
Move the cursor right
Move up the cursor
Move the cursor down
Move the cursor to the beginning of the line
Move the cursor to the end of the line
Move the cursor to the beginning of the document	+
Move the cursor to the end of the document	+
Move up the cursor one screen
Move the cursor down one screen
Moves the cursor one word to the right	+
Moves the cursor one word to the left	+
Moves the cursor to the top of the document	+
Moves the cursor to the bottom of the document	+

Text Selection keyboard shortcuts

Action	Shortcut
Select text from the cursor to the start of the current line	+
Select text from the cursor to the end of the current line	+
Select text from the cursor to the beginning of the document	++
Select text from the cursor to the end of the document	++
Select text up line by line starting from the cursor	+
Select text down line by line starting from the cursor	+
Select the word containing the cursor, or the closest word	+
Select the current location in the editor, back to the previous location in the editor	+
Select the entire current document	+
Move the cursor one character to the left and extend the selection	+
Move the cursor one character to the left and extend the column selection	++
Move the cursor one character to the right and extend the selection	+
Move the cursor one character to the right and extend the column selection	++
Move the cursor to the start of the current line and extend the column selection	++
Move the cursor to the end of the line and extend the column selection	++
Move the cursor to the right one word and extend the selection	+++
Move the cursor to the left one word and extend the selection	+++
Move the cursor up one line and extend the selection	++
Move the cursor down one line and extend the selection	++
Move the cursor up one page and extend the selection	+
Move the cursor down one page and extend the selection	+
Extend the selection to the top of the current window	++
Extend the selection to the bottom of the current window	++
Select the text from the current location of the cursor to the Navigate Backward (+) location	+
Go back to the previous document or window in the navigation history	+
Go forward to the next document or window in the navigation history	++
Swaps the anchor and end points of the current selection	+, +

Code Editor keyboard shortcuts

All shortcuts aren't implemented in all types of code editors.

Action	Shortcut
Toggle the full-screen display	++
Scroll text up one line	+
Scroll text down one line	+
Reverse the last editing action	+ or +
Restore the previously undone edit	++ or + or ++
Save the selected item	+
Save all	++
Close	+
Exit	+
Delete all text in the current file	++
Display the Go To Line dialog box	+
Increase line indent
Decrease line indent	+
Make the selected text uppercase	++
Make the selected text lowercase	++
Comment the selected text	+, +
Uncomment the selected text	+, +
Open a new query with current connection	+
Specify values for template parameters	++
Run the selected portion of the query editor or the entire query editor if nothing is selected
Parse the selected portion of the query editor or the entire query editor if nothing is selected	+
Display the estimated execution plan	+
Cancel the executing query	+
Include actual execution plan in the query output	+
Output results in a grid	+
Output results in text format	+
Output results to a file	++
Show or hide the query results pane	+
Toggle between query and results pane
Copy the result grid and headers to the clipboard	++
Open SQL Server Profiler	++
Display the Query Designer dialog from the query editor window	++
Run the `sp_help` system stored procedure	+
Run the `sp_who` system stored procedure	+
Run the `sp_lock` system stored procedure	+
Print	+

Note

Additional keyboard shortcuts can be configured to execute stored procedures in Tools > Options > Keyboard > Query Shortcuts.

Text Manipulation in Code Editor keyboard shortcuts

Action	Shortcut
Insert a new line	or +
Delete one character to the right of the cursor
Delete one character to the left of the cursor	or +
Delete whitespace in the selection, or deletes whitespace next to the cursor if there's no selection	+, +
Insert the number of spaces configured for the editor (configured in Tools > Options > Text Editor > All Languages > Tabs)
Insert a blank line above the cursor	+
Insert a blank line below the cursor	++
Change the selected text to lowercase	++
Change the selected text to uppercase	++
Toggle between insert mode and overtype mode
Move selected lines to the left on tab stop	+
Delete the word to the right of the cursor	+
Delete the word to the left of the cursor	+
Move the line containing the cursor below the next line	++
Toggle outlining expansion for the selected outline	+, +
Toggle all outlining for the active query editor	+, +
Remove all outlining information active query editor	+, +

Microsoft IntelliSense keyboard shortcuts

Action	Shortcut
Enable or disable IntelliSense	+, +
List members	+
Complete word	or
Launch code snippet picker	+, +
Refresh local cache	++
Launch Surround With snippet picker	+, +
Display the Code Snippet Manager	+, +

Solution Explorer keyboard shortcuts

Action	Shortcut
Display Solution Explorer	++
Display the New File dialog box to create a new file	++
Display the New Project dialog box to create a new project	++
Display the Open File dialog box to open an existing file	+
Change the name of the selected object

Bookmark keyboard shortcuts

Action	Shortcut
Set or remove a bookmark at the current line	+, +
Next bookmark	+, +
If the current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark isn't in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped.	++, ++
Previous bookmark	+, +
If the current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark isn't in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped.	++, ++
Clear bookmarks	+, +

Tree Control keyboard shortcuts

Action	Shortcut
Collapse tree nodes	(on the numeric keypad)
Expand all tree nodes	(on the numeric keypad)
Move up the tree control in the window
Move the tree control down in the window

Help and Microsoft Learn keyboard shortcuts

Action	Shortcut
Help	or +
Display SQL Server Documentation	+
Open the Help Library Manager	++
Display the SQL Server Resource Center Web page	++
Display help for the current editor window	+

Search keyboard shortcuts

Action	Shortcut
Display the Find dialog box	+
Display the Replace dialog box	+
Display the Replace in Files dialog box	++
Find the next occurrence of the search text
Find the previous occurrence of the search text	+

Cut and Paste keyboard shortcuts

Action	Shortcut
Copy to the Clipboard	+ or +
Paste from the Clipboard at the insertion point	+ or +
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item	++
Cut (delete the currently selected item and place it to the Clipboard)	+

Activity Monitor keyboard shortcuts

Action	Shortcut
Launches Activity Monitor	++
Closes Activity Monitor	+
Refresh
Cycle through panels
Copies entire selected row in grid	+
Copy cell	++
Dropdown list for filtering in grid	+
Scroll up or down Activity Monitor	++/

Replication Monitor keyboard shortcuts

Action	Shortcut
Refresh
Open a detail window from a grid

Replication Conflict Viewer keyboard shortcuts

Action	Shortcut
Define filter
Apply filter
Show all columns

Query Designer keyboard shortcuts

Action	Shortcut
Displays or hides the diagram pane of the Query Designer	+
Displays or hides the criteria pane of the Query Designer	+
Displays or hides the SQL pane of the Query Designer	+

View Query Designer keyboard shortcuts

Action	Shortcut
Displays or hides the diagram pane of the Query Designer	+
Displays or hides the criteria pane of the Query Designer	+
Displays or hides the SQL pane of the Query Designer	+

Table Designer keyboard shortcuts

Action	Shortcut
Move up the list of controls on the design surface
Move down the list of controls on the design surface
Move right in the list of selected controls on the design surface
Move left in the list of selected controls on the design surface
Move forward through the options of the selected control	+
Move backward through the options of the selected control	+
Moves to the next control on the page
Moves to the previous control on the page	+
Display the grid on the design surface

Feedback

Was this page helpful?

Additional resources

Last updated on

URL: https://learn.microsoft.com/en-us/ssms/sql-server-management-studio-keyboard-shortcuts