SQL Server Management Studio (SSMS) Tastatürkürzel 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Tastaturkürzel
1
Alt

Move to the SQL Server Management Studio menu bar

-1
Alt + +

Activate the menu for a tool component

1
↑  Shift + F10

Display the context menu

0
Ctrl + N

Display the New File dialog box to create a file

-1
Ctrl + ↑  Shift + N

Display the New Project dialog box to create a new project

1
Ctrl + O

Display the Open File dialog box to open an existing file

1
Ctrl + ↑  Shift + G

Display the Open File dialog box to open an existing file

0
Ctrl + ↑  Shift + O

Display the Open Project dialog box to open an existing project

0
Ctrl + ↑  Shift + A

Display the Add New Item dialog box to add a new file to the current project

0
↑  Shift + Alt + A

Display the Add Existing Item dialog box to add an existing file to the current project

-1
Ctrl + ↑  Shift + Q

Display the Query Designer

-1
Esc

Close a menu or dialog box, canceling the action

Werbung

0
Ctrl + F4

Close the current MDI child window

1
Esc

Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window

0
Ctrl + P

Print

0
Alt + F4

Exit

0
↑  Shift + Alt + ⤶ Enter

Toggle full screen mode

0
↑  Shift + Esc

Close the current tool window

1
Ctrl + F6

Cycle through the next MDI child windows

0
Ctrl + Tab

Display the IDE navigator with the first document window selected

0
Ctrl + ↑  Shift + Tab

Cycle through the previous MDI child windows

-1
Ctrl + F2

Moves the insertion point to the drop-down bar located at the top of the code editor when the editor is in Code view or Server Code view

0
↑  Shift + Alt

Move to the current tool window toolbar

0
Alt + F7

Display the IDE navigator with the first tool window selected

0
Alt + F6

Move to the next tool window

0
F6

(in the Database Engine Query Editor)  Move to the next tool window

0
↑  Shift + Alt + F7

Move to the previous tool window

1
F6

Move to the next pane of a split pane view of a single document

1
↑  Shift + Alt + F6

Move to the previously selected window

1
↑  Shift + F6

(in the Database Engine Query Editor) Move to the next pane of a split pane view of a single document

0
↑  Shift + F6

Move to the previous pane of a split pane view of a single document

0
Alt + -

Display the dock menu

0
Ctrl + Alt +

Display a popup listing all open windows

1
Ctrl + O

Opens a new query editor window

1
F8

Display Object Explorer

0
Ctrl + Alt + G

Display Registered Servers

1
Ctrl + Alt + T

Display Template Explorer

0
Ctrl + Alt + L

Display Solution Explorer

0
F7

Display the Summary Window

0
F4

Display the Properties Window

0
Ctrl + Alt + O

Display the Output window

0
Ctrl + \

then T: Display the Task List window

1
Ctrl + \

then Ctrl + T: Display the Task List window

0
F6

Toggle between Object Explorer Details list view and Object Explorer Details property pane

0
Tab

then UP arrow or DOWN arrow:  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

0
Ctrl + Alt + X

Display the Toolbox

0
Ctrl + K

then Ctrl + W: Display the Bookmarks Window

0
Ctrl + Alt + R

Display the Browser Window

1
↑  Shift + Alt + F10

Display a smart tag menu of common commands for Web server controls in the HTML designer

0
Ctrl + \

then Ctrl + E  Display the Error List Window (Transact-SQL Editor only)

0
Ctrl + \

E Display a smart tag menu of common commands for Web server controls in the HTML designer

0
Ctrl + \

then E   Display the Error List Window (Transact-SQL Editor only)

0
Ctrl + ↑  Shift + F12

Move to the next entry in the Error List window (Transact-SQL Editor only)

0
Alt +

Display the previous page in the viewing history. Available only in the Web browser window

0
Alt +

Display the next page in the viewing history. Available only in the Web browser window

0

Move the cursor left

0

Move the cursor right

Werbung

0

Move the cursor up

0

Move the cursor down

-1
Home

Move the cursor to the beginning of the line

0
End

Move the cursor to the end of the line

0
Ctrl + Home

Move the cursor to the beginning of the document

0
Ctrl + End

Move the cursor to the end of the document

0
Page Up

Move the cursor up one screen

0
Page Down

Move the cursor down one screen

0
Ctrl +

Moves the cursor one word to the right

0
Ctrl +

Moves the cursor one word to the left

0
↑  Shift + F8

Returns the cursor to the last item

0
Ctrl + Page Up

Moves the cursor to the top of the document

0
Ctrl + Page Up

Moves to the previous tab in the document

0
Ctrl + Page Down

Moves the cursor to the bottom of the document

0
Ctrl + Page Down

Moves to the next tab in the document

1
Ctrl + ↑  Shift + Home

Select text from the cursor to the beginning of the document

1
Ctrl + ↑  Shift + End

Select text from the cursor to the end of the document

1
↑  Shift + Home

Select text from the cursor to the start of the current line

0
↑  Shift + Alt + Home

Moves the cursor to the start of the current line and extends the column selection

0
↑  Shift + End

Select text from the cursor to the end of the current line

0
↑  Shift + Alt + End

Moves the cursor to the end of the line, extending the column selection

0
↑  Shift +

Select text down line by line starting from the cursor

Note: I'm not sure if below shortcut is correct. It's listed in Microsoft's documents. Please let me know in comments if you know the correct one.
0
↑  Shift + Ctrl + Del

Moves the cursor down one line, extending the column selection

0
↑  Shift +

Moves the cursor one character to the left and extends the selection

0
↑  Shift + Alt +

Moves the cursor one character to the left and extends the column selection

0
↑  Shift +

Moves the cursor one character to the right and extends the selection

0
↑  Shift + Alt +

Moves the cursor one character to the right and extends the column selection

0
↑  Shift +

Select text up line by line starting from the cursor

0
↑  Shift + Alt +

Move the cursor up one line, extending the selection

0
Shift + Page Up

Extend selection up one page

0
Shift + Page Down

Extend selection down one page

0
Ctrl + A

Select the entire current document

0
Ctrl + W

Select the word containing the cursor, or the closest word

0
Ctrl + =

Select the current location in the editor, back to the previous location in the editor

0
Ctrl + Shift + Page Up

Extend the selection to the top of the current window

0
Ctrl + Shift + Page Down

Move the cursor to the last line in view, extending the selection

0
Ctrl + ↑  Shift +

Extend the selection one word to the right

0
Ctrl + ↑  Shift +

Extend the selection one word to the left

0
Ctrl + ↑  Shift + Alt +

Move the cursor to the right one word, extending the selection

0
Ctrl + ↑  Shift + Alt +

Move the cursor to the left one word, extending the selection

0
Ctrl + ↑  Shift + ]

Move the cursor to the next brace, extending the selection

0
Ctrl + =

Select the text from the current location of the cursor to the Navigate Backward (Ctrl + -) location

-1
Ctrl + -

Go back to the previous document or window in the navigation history

0
Ctrl + ↑  Shift + -

Go forward to the next document or window in the navigation history

0
Ctrl + K

then Ctrl + A: Swaps the anchor and end points of the current selection

0
Ctrl + Shift + Page Up

Moves the cursor to the first line in view, extending the selection

0
Ctrl + Shift + Page Down

Moves the cursor to the last line in view, extending the selection

0
Ctrl + K

then Ctrl + K: Set or remove a bookmark at the current line

0
Ctrl + K

then Ctrl + N  Next bookmark

0
Ctrl + ↑  Shift + K

then Ctrl + Shift + N: 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 is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped

0
Ctrl + K

then Ctrl + P:  Previous bookmark

0
Ctrl + ↑  Shift + K

then Ctrl + Shift + P:  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 is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped.

0
Ctrl + K

then Ctrl + L: Clear bookmarks

0
-

(on the numeric keypad) Collapse tree nodes

0
*

(on the numeric keypad) Expand all tree nodes

0
Ctrl +

Scroll the tree control up in the window

0
Ctrl +

Scroll the tree control down in the window

0
↑  Shift + Alt + ⤶ Enter

Toggle the full-screen display

0
Ctrl +

Scroll text up one line

0
Ctrl +

Scroll text down one line

1
Ctrl + Z

Reverse the last editing action

0
oder Alt + Backspace
0
Ctrl + ↑  Shift + Z

Restore the previously undone edit

0
oder Ctrl + Y
0
oder Alt + ↑  Shift + Backspace
0
Ctrl + S

Save the selected item

0
Ctrl + ↑  Shift + S

Save all

0
Ctrl + F4

Close

0
Ctrl + P

Print

0
Alt + F4

Exit

0
Ctrl + ↑  Shift + W

Open the current file in a browser

0
Ctrl + ↑  Shift + Del

Delete all text in the current file

0
Ctrl + G

Display the Go To Line dialog box

0
Ctrl + +

Display the Navigate To dialog box.

0
Tab

Increase line indent

0
↑  Shift + Tab

Decrease line indent

0
Ctrl + ↑  Shift + U

Make the selected text upper case

0
Ctrl + U

Make the selected text lower case

0
Ctrl + K

then Ctrl + C:  Make the selected text a comment

-1
Ctrl + K

then Ctrl + U:  Uncomment the selected text

0
Ctrl + N

Open a new query with current connection

0
Alt + F8

Open database in Object Explorer

0
Ctrl + ↑  Shift + M

Specify values for template parameters

0
F5

Run the selected portion of the query editor or the entire query editor if nothing is selected

0
oder Ctrl + ↑  Shift + E

Teilen Sie diese Seite auf:
Ist diese Seite hilfreich?
0 0

Was ist Ihr Lieblings-Hotkey für SQL Server Management Studio (SSMS) ? Habt ihr dazu nützliche Tipps? Informieren Sie unten andere Benutzer darüber.


Nur registrierte Benutzer können Links posten.
 
Noch keine Kommentare. Fragen Sie oder geben Sie den ersten ein!

Neueste Artikel