SQL Server Management Studio 鍵盤快速鍵SQL Server Management Studio Keyboard Shortcuts

本主題適用於: 是SQL Server是Azure SQL Database是Azure SQL 資料倉儲 是平行處理資料倉儲 THIS TOPIC APPLIES TO: yesSQL ServeryesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Transact-SQLSQL Server Management Studio 為使用者提供了兩種鍵盤配置。 Transact-SQLSQL Server Management Studio offers users two keyboard schemes. 根據預設,它會使用 SQL Server 2017SQL Server 2017 配置,其鍵盤快速鍵是以 MicrosoftMicrosoft Visual StudioVisual Studio 2010 為基礎。By default, it uses the SQL Server 2017SQL Server 2017 scheme, with keyboard shortcuts based on MicrosoftMicrosoft Visual StudioVisual Studio 2010. Management StudioManagement Studio 也提供了類似於 SQL Server 2008 R2SQL Server 2008 R2中標準配置的鍵盤配置。 Management StudioManagement Studio also offers a keyboard scheme similar to the standard scheme from SQL Server 2008 R2SQL Server 2008 R2. 若要變更鍵盤配置或加入其他鍵盤快速鍵,請在 [工具] 功能表上,按一下 [選項]。To change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options. 請在 [環境]、[鍵盤] 頁面上,選取所需要的鍵盤配置。Select the desired keyboard scheme on the Environment, Keyboard page.

注意

若要只顯示標題,請按一下這個頁面頂端的 [全部摺疊]。To show only the headings, click Collapse All at the top of this page.

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
移到 Transact-SQLSQL Server Management Studio 功能表列Move to the Transact-SQLSQL Server Management Studio menu bar ALTALT ALTALT
啟動工具元件的功能表Activate the menu for a tool component ALT+連字號ALT+HYPHEN ALT+連字號ALT+HYPHEN
顯示操作功能表Display the context menu SHIFT+F10SHIFT+F10 SHIFT+F10SHIFT+F10
顯示 [新增檔案] 對話方塊來建立檔案Display the New File dialog box to create a file CTRL+NCTRL+N CTRL+NCTRL+N
顯示 [新增專案] 對話方塊來建立新專案Display the New Project dialog box to create a new project CTRL+SHIFT+NCTRL+SHIFT+N CTRL+SHIFT+NCTRL+SHIFT+N
顯示 [開啟檔案] 對話方塊來開啟現有的檔案Display the Open File dialog box to open an existing file CTRL+OCTRL+O

中的多個or

CTRL+SHIFT+GCTRL+SHIFT+G
CTRL+OCTRL+O
顯示 [開啟專案] 對話方塊來開啟現有的專案Display the Open Project dialog box to open an existing project CTRL+SHIFT+OCTRL+SHIFT+O CTRL+SHIFT+OCTRL+SHIFT+O
顯示 [加入新項目] 對話方塊來將新檔案加入目前的專案Display the Add New Item dialog box to add a new file to the current project CTRL+SHIFT+ACTRL+SHIFT+A CTRL+SHIFT+ACTRL+SHIFT+A
顯示 [加入現有項目] 對話方塊來將現有檔案加入目前的專案Display the Add Existing Item dialog box to add an existing file to the current project SHIFT+ALT+ASHIFT+ALT+A SHIFT+ALT+ASHIFT+ALT+A
顯示查詢設計工具Display the Query Designer CTRL+SHIFT+QCTRL+SHIFT+Q CTRL+SHIFT+QCTRL+SHIFT+Q
關閉功能表或對話方塊,取消動作Close a menu or dialog box, canceling the action ESCESC ESCESC

視窗管理和工具列鍵盤快速鍵Windows Management and Toolbar Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
關閉目前的 MDI 子視窗Close the current MDI child window CTRL+F4CTRL+F4 CTRL+F4CTRL+F4
關閉功能表或對話方塊、取消正在進行中的操作,或者將焦點放在目前的文件視窗Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window ESCESC ESCESC
列印Print CTRL+PCTRL+P CTRL+PCTRL+P
結束Exit ALT+F4ALT+F4 ALT+F4ALT+F4
切換全螢幕模式Toggle full screen mode SHIFT+ALT+ENTERSHIFT+ALT+ENTER SHIFT+ALT+ENTERSHIFT+ALT+ENTER
關閉目前的工具視窗Close the current tool window SHIFT+ESCSHIFT+ESC SHIFT+ESCSHIFT+ESC
循環瀏覽後續的 MDI 子視窗Cycle through the next MDI child windows CTRL+F6CTRL+F6 CTRL+TABCTRL+TAB
在選取第一個文件視窗時,顯示 IDE 導覽器Display the IDE navigator with the first document window selected CTRL+TABCTRL+TAB 沒有對等項目No equivalent
循環瀏覽先前的 MDI 子視窗Cycle through the previous MDI child windows CTRL+SHIFT+TABCTRL+SHIFT+TAB CTRL+SHIFT+TABCTRL+SHIFT+TAB
當編輯器位於 [程式碼] 檢視或 [伺服端程式碼] 檢視時,將插入點移到位於程式碼編輯器上方的下拉式清單列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 CTRL+F2CTRL+F2 沒有對等項目No equivalent
移到目前的工具視窗工具列Move to the current tool window toolbar SHIFT+ALTSHIFT+ALT SHIFT+ALTSHIFT+ALT
在選取第一個工具視窗時,顯示 IDE 導覽器Display the IDE navigator with the first tool window selected ALT+F7ALT+F7 沒有對等項目No equivalent
移到下一個工具視窗Move to the next tool window ALT+F6ALT+F6

中的多個or

Database EngineDatabase Engine 查詢編輯器中的 F6F6 in the Database EngineDatabase Engine Query Editor
ALT+F6ALT+F6
移到上一個工具視窗Move to the previous tool window SHIFT+ALT+F7SHIFT+ALT+F7 SHIFT+ALT+F7SHIFT+ALT+F7
移到單一文件分割窗格檢視的下一個窗格Move to the next pane of a split pane view of a single document F6F6 F6F6
移到先前選取的視窗Move to the previously selected window SHIFT+ALT+F6SHIFT+ALT+F6

中的多個or

Database EngineDatabase Engine 查詢編輯器中的 SHIFT+F6SHIFT+F6 in the Database EngineDatabase Engine Query Editor
SHIFT+ALT+F6SHIFT+ALT+F6
移到單一文件分割窗格檢視的上一個窗格Move to the previous pane of a split pane view of a single document SHIFT+F6SHIFT+F6 F6F6
顯示停駐功能表Display the dock menu ALT+減號 (-)ALT+MINUS SIGN (-) 沒有對等項目No equivalent
顯示快顯視窗,列出所有開啟的視窗Display a popup listing all open windows CTRL+ALT+向下鍵CTRL+ALT+DOWN ARROW 沒有對等項目No equivalent
開啟新的查詢編輯器視窗Opens a new query editor window CTRL+OCTRL+O CTRL+OCTRL+O
顯示物件總管Display Object Explorer F8F8 F8F8
顯示已註冊的伺服器Display Registered Servers CTRL+ALT+GCTRL+ALT+G CTRL+ALT+GCTRL+ALT+G
顯示範本總管Display Template Explorer CTRL+ALT+TCTRL+ALT+T CTRL+ALT+TCTRL+ALT+T
顯示方案總管Display Solution Explorer CTRL+ALT+LCTRL+ALT+L CTRL+ALT+LCTRL+ALT+L
顯示摘要視窗Display the Summary Window F7F7 F7F7
顯示屬性視窗Display the Properties Window F4F4 F4F4
顯示 [輸出] 視窗Display the Output window CTRL+ALT+OCTRL+ALT+O 沒有對等項目No equivalent
顯示 [工作清單] 視窗Display the Task List window CTRL+\、TCTRL+\, T

中的多個or

CTRL+\、CTRL+TCTRL+\, CTRL+T
CTRL+ALT+KCTRL+ALT+K
在 [物件總管詳細資料] 清單檢視與 [物件總管詳細資料] 屬性窗格之間切換。Toggle between Object Explorer Details list view and Object Explorer Details property pane. F6F6 F6F6
控制分隔 [物件總管詳細資料] 清單檢視與 [物件總管詳細資料] 屬性窗格的分隔列,以便調整顯示窗格的大小。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. TAB,然後按向上鍵或向下鍵TAB, then UP arrow or DOWN arrow TAB,然後按向上鍵或向下鍵TAB, then UP arrow or DOWN arrow
顯示工具箱Display the Toolbox CTRL+ALT+XCTRL+ALT+X CTRL+ALT+XCTRL+ALT+X
顯示書籤視窗Display the Bookmarks Window CTRL+K、CTRL+WCTRL+K, CTRL+W CTRL+K、CTRL+WCTRL+K, CTRL+W
顯示瀏覽器視窗Display the Browser Window CTRL+ALT+RCTRL+ALT+R CTRL+ALT+RCTRL+ALT+R
顯示 HTML 設計工具中 Web 伺服器控制項之常用命令的智慧標籤功能表Display a smart tag menu of common commands for Web server controls in the HTML designer SHIFT+ALT+F10SHIFT+ALT+F10 沒有對等項目No equivalent
顯示錯誤清單視窗 (僅適用於 Transact-SQLTransact-SQL 編輯器)Display the Error List Window ( Transact-SQLTransact-SQL Editor only) CRTL+\、CTRL+ECRTL+\, CTRL+E

中的多個or

CTRL+\、ECTRL+\, E
CRTL+\、CTRL+ECRTL+\, CTRL+E
移到 [錯誤清單] 視窗中的下一個項目 (僅限 Transact-SQLTransact-SQL 編輯器)Move to the next entry in the Error List window ( Transact-SQLTransact-SQL Editor only) CTRL+SHIFT+F12CTRL+SHIFT+F12 CTRL+SHIFT+F12CTRL+SHIFT+F12
顯示檢視記錄中的上一頁。Display the previous page in the viewing history. 只能在 Web 瀏覽器視窗中使用Available only in the Web browser window ALT+向左鍵ALT+LEFT ARROW 沒有對等項目No equivalent
顯示檢視記錄中的下一頁。Display the next page in the viewing history. 只能在 Web 瀏覽器視窗中使用Available only in the Web browser window ALT+向右鍵ALT+RIGHT ARROW 沒有對等項目No equivalent

游標移動鍵盤快速鍵Cursor Movement Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
向左移動游標Move the cursor left 向左鍵LEFT ARROW 向左鍵LEFT ARROW
向右移動游標Move the cursor right 向右鍵RIGHT ARROW 向右鍵RIGHT ARROW
向上移動游標Move the cursor up 向上鍵UP ARROW 向上鍵UP ARROW
向下移動游標Move the cursor down DOWN ARROWDOWN ARROW DOWN ARROWDOWN ARROW
將游標移到行首Move the cursor to the beginning of the line HOMEHOME HOMEHOME
將游標移到行尾Move the cursor to the end of the line ENDEND ENDEND
將游標移到文件開頭Move the cursor to the beginning of the document CTRL+HOMECTRL+HOME CTRL+HOMECTRL+HOME
將游標移到文件結尾Move the cursor to the end of the document CTRL+ENDCTRL+END CTRL+ENDCTRL+END
將游標向上移動一個畫面Move the cursor up one screen PAGE UPPAGE UP PAGE UPPAGE UP
將游標向下移動一個畫面Move the cursor down one screen PAGE DOWNPAGE DOWN PAGE DOWNPAGE DOWN
將游標向右移動一個單字Moves the cursor one word to the right CTRL+向右鍵CTRL+ RIGHT ARROW CTRL+向右鍵CTRL+ RIGHT ARROW
將游標向左移動一個單字Moves the cursor one word to the left CTRL+向左鍵CTRL+ LEFT ARROW CTRL+向左鍵CTRL+ LEFT ARROW
讓游標返回最後一個項目。Returns the cursor to the last item. SHIFT+F8SHIFT+F8 沒有對等項目No equivalent
將游標移到文件上方Moves the cursor to the top of the document CTRL+PAGE UPCTRL+PAGE UP 沒有對等項目No equivalent
移至文件中的上一個索引標籤Moves to the previous tab in the document CTRL+PAGE UPCTRL+PAGE UP
將游標移到文件底部Moves the cursor to the bottom of the document CTRL+PAGE DOWNCTRL+PAGE DOWN 沒有對等項目No equivalent
移至文件中的下一個索引標籤Moves to the next tab in the document CTRL+PAGE DOWNCTRL+PAGE DOWN 沒有對等項目No equivalent

文字選取範圍鍵盤快速鍵Text Selection Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
選取從游標到文件開頭的文字Select text from the cursor to the beginning of the document CTRL+SHIFT+ HOMECTRL+SHIFT+ HOME CTRL+SHIFT+ HOMECTRL+SHIFT+ HOME
選取從游標到文件結尾的文字Select text from the cursor to the end of the document CTRL+SHIFT+ENDCTRL+SHIFT+END CTRL+SHIFT+ENDCTRL+SHIFT+END
選取從游標到目前這一行開頭的文字Select text from the cursor to the start of the current line SHIFT+HOMESHIFT+HOME SHIFT+HOMESHIFT+HOME
將游標移到目前這一行開頭,並擴充資料行選取Moves the cursor to the start of the current line and extends the column selection SHIFT+ALT+HOMESHIFT+ALT+HOME 沒有對等項目No equivalent
選取從游標到目前這一行結尾的文字Select text from the cursor to the end of the current line SHIFT+ENDSHIFT+END SHIFT+ENDSHIFT+END
將游標移到行尾,並擴充資料行選取。Moves the cursor to the end of the line, extending the column selection. SHIFT+ALT+ENDSHIFT+ALT+END 沒有對等項目No equivalent
從游標開始,向下逐行選取文字Select text down line by line starting from the cursor SHIFT+ 向下鍵SHIFT+ DOWN ARROW SHIFT+ 向下鍵SHIFT+ DOWN ARROW
將游標下移一行,擴充資料行選取Moves the cursor down one line, extending the column selection SHIFT+ Ctrl+Shift+DelSHIFT+ Ctrl+Shift+Del
將游標向左移動一個字元,並擴充選取範圍Moves the cursor one character to the left and extends the selection SHIFT+向左鍵SHIFT+LEFT ARROW 沒有對等項目No equivalent
將游標向左移動一個字元,並擴充資料行選取Moves the cursor one character to the left and extends the column selection SHIFT+ALT+向左鍵SHIFT+ALT+LEFT ARROW 沒有對等項目No equivalent
將游標向右移動一個字元,並擴充選取範圍Moves the cursor one character to the right and extends the selection SHIFT+向右鍵SHIFT+RIGHT ARROW 沒有對等項目No equivalent
將游標向右移動一個字元,並擴充資料行選取Moves the cursor one character to the righTt and extends the column selection SHIFT+ALT+向右鍵SHIFT+ALT+RIGHT ARROW 沒有對等項目No equivalent
從游標開始,向上逐行選取文字Select text up line by line starting from the cursor SHIFT+向上鍵SHIFT+UP ARROW SHIFT+向上鍵SHIFT+UP ARROW
將游標向上移動一行,延伸選取範圍Move the cursor up one line, extending the selection SHIFT+ALT+ 向上鍵SHIFT+ALT+ UP ARROW SHIFT+ALT+ 向上鍵SHIFT+ALT+ UP ARROW
將選取範圍向上移動一個頁面Extend selection up one page SHIFT+ PAGE UPSHIFT+ PAGE UP SHIFT+ PAGE UPSHIFT+ PAGE UP
將選取範圍向下移動一個頁面Extend selection down one page SHIFT+ PAGE DOWNSHIFT+ PAGE DOWN SHIFT+ PAGE DOWNSHIFT+ PAGE DOWN
選取整份目前的文件Select the entire current document CTRL+ACTRL+A CTRL+ACTRL+A
選取游標所在的單字,或最接近的單字Select the word containing the cursor, or the closest word CTRL+WCTRL+W CTRL+WCTRL+W
選取編輯器中目前的位置,返回編輯器中上一個位置Select the current location in the editor, back to the previous location in the editor CTRL+=CTRL+= CTRL+=CTRL+=
將選取範圍延伸至目前視窗的頂端Extend the selection to the top of the current window CTRL+SHIFT+ PAGE UPCTRL+SHIFT+ PAGE UP CTRL+SHIFT+ PAGE UPCTRL+SHIFT+ PAGE UP
將游標移到檢視中的最後一行,延伸選取範圍Move the cursor to the last line in view, extending the selection CTRL+SHIFT+ PAGE DOWNCTRL+SHIFT+ PAGE DOWN CTRL+SHIFT+ PAGE DOWNCTRL+SHIFT+ PAGE DOWN
將選取範圍向右延伸一個單字Extend the selection one word to the right CTRL+SHIFT+ 向右鍵CTRL+SHIFT+ RIGHT ARROW CTRL+SHIFT+ 向右鍵CTRL+SHIFT+ RIGHT ARROW
將選取範圍向左延伸一個單字Extend the selection one word to the left CTRL+SHIFT+ 向左鍵CTRL+SHIFT+ LEFT ARROW CTRL+SHIFT+ 向左鍵CTRL+SHIFT+ LEFT ARROW
將游標向右移動一個單字,延伸選取範圍Move the cursor to the right one word, extending the selection CTRL+SHIFT+ALT+ 向右鍵CTRL+SHIFT+ALT+ RIGHT ARROW CTRL+SHIFT+ALT+ 向右鍵CTRL+SHIFT+ALT+ RIGHT ARROW
將游標向左移動一個單字,擴充選取範圍Move the cursor to the left one word, extending the selection CTRL+SHIFT+ALT+ 向左鍵CTRL+SHIFT+ALT+ LEFT ARROW CTRL+SHIFT+ALT+ 向左鍵CTRL+SHIFT+ALT+ LEFT ARROW
將游標移到下一個大括號,擴充選取範圍Move the cursor to the next brace, extending the selection CTRL+SHIFT+]CTRL+SHIFT+] 沒有對等項目No equivalent
選取從游標的目前位置到向後導覽 (CTRL+減號 (-)) 位置的文字Select the text from the current location of the cursor to the Navigate Backward (CTRL+MINUS SIGN (-)) location CTRL+等號 (=)CTRL+EQUAL SIGN (=) 沒有對等項目No equivalent
回到導覽記錄中的上一個文件或視窗Go back to the previous document or window in the navigation history CTRL+減號 (-)CTRL+MINUS SIGN (-) 沒有對等項目No equivalent
向前移到導覽記錄中的下一個文件或視窗Go forward to the next document or window in the navigation history CTRL+SHIFT+減號 (-)CTRL+SHIFT+MINUS SIGN (-) 沒有對等項目No equivalent
交換目前選取範圍的錨點和端點Swaps the anchor and end points of the current selection CTRL+K、CTRL+ACTRL+K, CTRL+A 沒有對等項目No equivalent
將游標移到檢視中的第一行,擴充選取範圍Moves the cursor to the first line in view, extending the selection CTRL+SHIFT+PAGE UPCTRL+SHIFT+PAGE UP 沒有對等項目No equivalent
將游標移到檢視中的最後一行,擴充選取範圍Moves the cursor to the last line in view, extending the selection CTRL+SHIFT+PAGE DOWNCTRL+SHIFT+PAGE DOWN 沒有對等項目No equivalent

書籤鍵盤快速鍵Bookmark Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
設定或移除目前這一行的書籤Set or remove a bookmark at the current line CTRL+K、CTRL+KCTRL+K, CTRL+K CTRL+K、CTRL+KCTRL+K, CTRL+K
下一個書籤Next bookmark CTRL+K、CTRL+NCTRL+K, CTRL+N CTRL+K、CTRL+NCTRL+K, CTRL+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.
CTRL+SHIFT+K、CTRL+SHIFT+NCTRL+SHIFT+K, CTRL+SHIFT+N 沒有對等項目No equivalent
上一個書籤Previous bookmark CTRL+K、CTRL+PCTRL+K, CTRL+P CTRL+K、CTRL+PCTRL+K, CTRL+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.
CTRL+SHIFT+K、CTRL+SHIFT+PCTRL+SHIFT+K, CTRL+SHIFT+P 沒有對等項目No equivalent
清除書籤Clear bookmarks CTRL+K、CTRL+LCTRL+K, CTRL+L CTRL+K、CTRL+LCTRL+K, CTRL+L

樹狀控制項鍵盤快速鍵Tree Control Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
摺疊樹狀節點Collapse tree nodes - (在數字鍵台上)- (on the numeric keypad) - (在數字鍵台上)- (on the numeric keypad)
展開所有樹狀節點Expand all tree nodes * (數字鍵台)* (on the numeric keypad) * (數字鍵台)* (on the numeric keypad)
在視窗中,向上捲動樹狀控制項Scroll the tree control up in the window CTRL+向上鍵CTRL+UP ARROW CTRL+向上鍵CTRL+UP ARROW
在視窗中,向下捲動樹狀控制項Scroll the tree control down in the window CTRL+向下鍵CTRL+DOWN ARROW CTRL+向下鍵CTRL+DOWN ARROW

程式碼編輯器鍵盤快速鍵Code Editor Keyboard Shortcuts

並非所有快速鍵都會在所有類型的程式碼編輯器中實作。All shortcuts are not implemented in all types of code editors.

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
切換全螢幕顯示畫面Toggle the full-screen display SHIFT+ALT+ENTERSHIFT+ALT+ENTER SHIFT+ALT+ENTERSHIFT+ALT+ENTER
將文字向上捲動一行Scroll text up one line CTRL+向上鍵CTRL+UP ARROW CTRL+向上鍵CTRL+UP ARROW
將文字向下捲動一行Scroll text down one line CTRL+向下鍵CTRL+DOWN ARROW CTRL+向下鍵CTRL+ DOWN ARROW
反轉上一個編輯動作Reverse the last editing action CTRL+ZCTRL+Z

中的多個or

ALT+退格鍵ALT+BACKSPACE
CTRL+ZCTRL+Z
還原先前恢復的編輯Restore the previously undone edit CTRL+SHIFT+ZCTRL+SHIFT+Z

中的多個or

CTRL+YCTRL+Y

中的多個or

ALT+SHIFT+退格鍵ALT+SHIFT+BACKSPACE
CTRL+SHIFT+ZCTRL+SHIFT+Z

中的多個or

CTRL+YCTRL+Y

中的多個or

ALT+SHIFT+退格鍵ALT+SHIFT+BACK SPACE
儲存所選的項目Save the selected item CTRL+SCTRL+S CTRL+SCTRL+S
全部儲存Save all CTRL+SHIFT+SCTRL+SHIFT+S CTRL+SHIFT+SCTRL+SHIFT+S
關閉Close CTRL+F4CTRL+F4 CTRL+F4CTRL+F4
列印Print CTRL+PCTRL+P CTRL+PCTRL+P
結束Exit ALT+F4ALT+F4 ALT+F4ALT+F4
在瀏覽器中開啟目前的檔案Open the current file in a browser CTRL+SHIFT+WCTRL+SHIFT+W 沒有對等項目No equivalent
刪除目前檔案中的所有文字Delete all text in the current file CTRL+SHIFT+DELCTRL+SHIFT+DEL CTRL+SHIFT+DELCTRL+SHIFT+DEL
顯示 [移至行] 對話方塊Display the Go To Line dialog box CTRL+GCTRL+G CTRL+GCTRL+G
顯示 [巡覽至] 對話方塊。Display the Navigate To dialog box. CTRL+加號 (+)CTRL+PLUS SIGN (+) 沒有對等項目No equivalent
增加行縮排Increase line indent TABTAB TABTAB
減少行縮排Decrease line indent SHIFT+TABSHIFT+TAB SHIFT+TABSHIFT+TAB
使所選的文字成為大寫Make the selected text upper case CTRL+SHIFT+UCTRL+SHIFT+U CTRL+SHIFT+UCTRL+SHIFT+U
使所選的文字成為小寫Make the selected text lower case CTRL+UCTRL+U CTRL+SHIFT+LCTRL+SHIFT+L
讓所選的文字變成註解Make the selected text a comment CTRL+K、CTRL+CCTRL+K, CTRL+C CTRL+K、CTRL+CCTRL+K, CTRL+C
將所選的文字取消註解Uncomment the selected text CTRL+K、CTRL+UCTRL+K, CTRL + U CTRL+K、CTRL+UCTRL+K, CTRL + U
利用目前的連接來開啟新的查詢Open a new query with current connection CTRL+NCTRL+N CTRL+NCTRL+N
在物件總管中開啟資料庫Open database in Object Explorer ALT+F8ALT+F8 ALT+F8ALT+F8
指定範本參數的值Specify values for template parameters CTRL+SHIFT+MCTRL+SHIFT+M CTRL+SHIFT+MCTRL+SHIFT+M
執行查詢編輯器的選定部分,如果未選取任何部分,則剖析整個查詢編輯器Run the selected portion of the query editor or the entire query editor if nothing is selected F5F5

中的多個or

CTRL+SHIFT+ECTRL+SHIFT+E
F5F5

中的多個or

CTRL+ECTRL+E

中的多個or

ALT+XALT+X
剖析查詢編輯器的選定部分,如果未選取任何部分,則剖析整個查詢編輯器Parse the selected portion of the query editor or the entire query editor if nothing is selected CTRL+F5CTRL+F5 CTRL+F5CTRL+F5
顯示預估執行計畫Display the estimated execution plan CTRL+SHIFT+ALT+LCTRL+SHIFT+ALT+L CTRL+LCTRL+L
取消執行查詢Cancel the executing query ALT+BREAKALT+BREAK ALT+BREAKALT+BREAK
在查詢輸出中併入實際的執行計畫Include actual execution plan in the query output CTRL+SHIFT+ALT+MCTRL+SHIFT+ALT+M CTRL+MCTRL+M
在方格中輸出結果Output results in a grid CTRL+SHIFT+DCTRL+SHIFT+D CTRL+DCTRL+D
輸出文字格式的結果Output results in text format CTRL+TCTRL+T CTRL+TCTRL+T
將結果輸出到檔案中Output results to a file CTRL+SHIFT+TCTRL+SHIFT+T CTRL+SHIFT+FCTRL+SHIFT+F
顯示或隱藏查詢結果窗格Show or hide the query results pane CTRL+RCTRL+R CTRL+RCTRL+R
顯示查詢結果窗格Show the query results pane CTRL+SHIFT+ALT+RCTRL+SHIFT+ALT+R
切換查詢和結果窗格Toggle between query and results pane F6F6 F6F6
將結果方格和標頭複製至剪貼簿Copy the result grid and headers to the clipboard CTRL+SHIFT+CCTRL+SHIFT+C 沒有對等項目No equivalent
移到 Management StudioManagement Studio 中的下一個使用中視窗Move to the next active window in Management StudioManagement Studio ALT+F6ALT+F6 ALT+F6ALT+F6
開啟 SQL Server ProfilerSQL Server ProfilerOpen SQL Server ProfilerSQL Server Profiler CTRL+ALT+PCTRL+ALT+P CTRL+ALT+PCTRL+ALT+P
從查詢編輯器視窗顯示 [查詢設計工具] 對話方塊Display the Query Designer dialog from the query editor window CTRL+SHIFT+QCTRL+SHIFT+Q 沒有對等項目No equivalent
執行 sp_help 系統預存程序Run the sp_help system stored procedure ALT+F1ALT+F1 ALT+F1ALT+F1
執行 sp_who 系統預存程序Run the sp_who system stored procedure CTRL+1CTRL+1 CTRL+1CTRL+1
執行 sp_lock 系統預存程序Run the sp_lock system stored procedure CTRL+2CTRL+2 CTRL+2CTRL+2
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+3CTRL+3 CTRL+3CTRL+3
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+4CTRL+4 CTRL+4CTRL+4
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+5CTRL+5 CTRL+5CTRL+5
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+6CTRL+6 CTRL+6CTRL+6
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+7CTRL+7 CTRL+7CTRL+7
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+7CTRL+7 CTRL+7CTRL+7
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+8CTRL+8 CTRL+8CTRL+8
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+9CTRL+9 CTRL+9CTRL+9
在 [工具]、[選項]、[鍵盤]、[查詢快速鍵] 對話方塊中執行針對這個快速鍵設定的預存程序Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog CTRL+0CTRL+0 CTRL+0CTRL+0

在程式碼編輯器鍵盤快速鍵中操作文字Text Manipulation in Code Editor Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
插入新行Insert a new line ENTER 或 SHIFT+ENTERENTER or SHIFT+ENTER ENTER 或 SHIFT+ENTERENTER or SHIFT+ENTER
交換游標兩邊的字元 (不適用於 SQL 編輯器)。Swap the characters on either side of the cursor (Does not apply to the SQL Editor.) CTRL+TCTRL+T CTRL+TCTRL+T
刪除游標右側的一個字元Delete one character to the right of the cursor DeleteDELETE DeleteDELETE
刪除游標左側的一個字元Delete one character to the left of the cursor 退格鍵BACKSPACE

中的多個or

SHIFT+SHIFT+

退格鍵BACKSPACE
退格鍵BACKSPACE

中的多個or

SHIFT+SHIFT+

退格鍵BACKSPACE
在選取範圍中刪除空白字元,如果未選取任何範圍則刪除游標旁邊的空白字元Delete whitespace in the selection, or deletes whitespace adjacent to the cursor if there is no selection CTRL+K、CCTRL+K, C 沒有對等項目No equivalent
插入為編輯器所設定的空格數Insert the number of spaces configured for the editor TABTAB TABTAB
在游標上插入空白行Insert a blank line above the cursor CTRL+ENTERCTRL+ENTER CTRL+ENTERCTRL+ENTER
在游標下插入空白行Insert a blank line below the cursor CTRL+SHIFT+ ENTERCTRL+SHIFT+ ENTER CTRL+SHIFT+ ENTERCTRL+SHIFT+ ENTER
將所選的文字改成小寫Change the selected text to lowercase CTRL+SHIFT+LCTRL+SHIFT+L CTRL+SHIFT+LCTRL+SHIFT+L
將所選的文字改成大寫Change the selected text to uppercase CTRL+SHIFT+UCTRL+SHIFT+U CTRL+SHIFT+UCTRL+SHIFT+U
切換插入模式和取代模式Toggle between insert mode and overtype mode INSERTINSERT InsertINSERT
將所選的行向左移到定位停駐點Move selected lines to the left on tab stop SHIFT+TABSHIFT+TAB SHIFT+TABSHIFT+TAB
刪除游標右側的單字Delete the word to the right of the cursor CTRL+DELETECTRL+DELETE CTRL+DELETECTRL+DELETE
刪除游標左側的單字Delete the word to the left of the cursor CTRL+空白鍵CTRL+BACKSPACE CTRL+空白鍵CTRL+BACKSPACE
在游標的任何一側調換單字 (不適用於 SQL 編輯器)。Transpose the words on either side of the cursor (Does not apply to the SQL Editor.) CTRL+SHIFT+TCTRL+SHIFT+T CTRL+SHIFT+TCTRL+SHIFT+T
將包含游標的那一行移到下一行底下Moves the line containing the cursor below the next line SHIFT+ALT+TSHIFT+ALT+T 沒有對等項目No equivalent
在 [選項] 對話方塊的 [文字編輯器] 區段中,針對語言的 [格式化] 窗格上所指定的語言套用縮排和空格格式。Applies the indenting and space formatting for the language specified on the Formatting pane of the language in the Text Editor section of the Options dialog. 只適用於文字編輯器。Available only in the text editor. CTRL+K、CTRL+DCTRL+K, CTRL+D 沒有對等項目No equivalent
根據程式碼周圍的行,讓選取的程式碼行正確縮排Correctly indents the selected lines of code based on the surrounding lines of code CTRL+K、CTRL+FCTRL+K, CTRL+F 沒有對等項目No equivalent
設定或移除目前這一行的捷徑Set or remove a shortcut in the current line CTRL+K、CTRL+HCTRL+K, CTRL+H 沒有對等項目No equivalent
從目前這一行移除註解語法Remove the comment syntax from the current line CTRL+K、CTRL+UCTRL+K, CTRL+U 沒有對等項目No equivalent
顯示或隱藏空格和定位點Shows or hides spaces and tabs CTRL+R、CTRL+WCTRL+R, CTRL+W 沒有對等項目No equivalent
啟用或停用編輯器中的自動換行Enables or disables word wrap in an editor Alt+F、CTRL+WAlt+F, CTRL+W 沒有對等項目No equivalent
摺疊所有大綱區域,只顯示階層中的最外面群組Collapses all outlining regions to show just the outermost groups in the hierarchy CTRL+M、CTRL+ACTRL+M, CTRL+A 沒有對等項目No equivalent
摺疊目前選取的大綱區域Collapses the currently selected outlining region CTRL+M、CTRL+SCTRL+M, CTRL+S 沒有對等項目No equivalent
展開頁面上的所有大綱區域Expands all outlining regions on the page CTRL+M、CTRL+XCTRL+M, CTRL+X 沒有對等項目No equivalent
展開目前選取的大綱區域Expands the currently selected outlining region CTRL+M、CTRL+ECTRL+M, CTRL+E 沒有對等項目No equivalent
摺疊現有的大綱區域Collapses existing outlining regions CTRL+M、CTRL+OCTRL+M, CTRL+O
隱藏選取的文字。Hides the selected text. 訊號圖示會標示隱藏文字的位置A signal icon marks the location of the hidden text CTRL+M、CTRL+HCTRL+M, CTRL+H 沒有對等項目No equivalent
在隱藏狀態和顯示狀態之間切換之前標記為隱藏的所有文字區段。Toggles all text sections previously marked as hidden between the hidden and display states. CTRL+M、CTRL+LCTRL+M, CTRL+L 沒有對等項目No equivalent
在隱藏狀態和顯示狀態之間切換目前選取的隱藏文字區段Toggles the currently selected hidden text section between the hidden and display states CTRL+M、CTRL+MCTRL+M, CTRL+M 沒有對等項目No equivalent
移除文件中的所有大綱資訊Removes all outlining information in the document CTRL+M、CTRL+PCTRL+M, CTRL+P 沒有對等項目No equivalent
移除目前選定區域的大綱資訊Removes the outlining information for the currently selected region CTRL+M、CTRL+UCTRL+M, CTRL+U 沒有對等項目No equivalent

Transact-SQL 偵錯工具鍵盤快速鍵Transact-SQL Debugger Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
開始或繼續偵錯Start or continue debugging ALT+F5ALT+F5 ALT+F5ALT+F5
停止偵錯Stop debugging SHIFT+F5SHIFT+F5 SHIFT+F5SHIFT+F5
逐步執行Step into F11F11 F11F11
逐程序Step over F10F10 F10F10
跳出Step out SHIFT+F11SHIFT+F11 SHIFT+F11SHIFT+F11
逐步執行特定陳述式Step into specific statement SHIFT+ALT+F11SHIFT+ALT+F11 沒有對等項目No equivalent
設定下一個陳述式Set next statement Ctrl+3 0Ctrl+3 0 沒有對等項目No equivalent
顯示下一個陳述式Show next statement ALT+NUMALT+NUM 沒有對等項目No equivalent
實作 [執行至資料指標處] 命令Implement the Run To Cursor command CTRL+F10CTRL+F10 CTRL+F10CTRL+F10
顯示 [快速監看式] 對話方塊Display the QuickWatch dialog box CTRL+ALT+QCTRL+ALT+Q

中的多個or

SHIFT+F9SHIFT+F9
CTRL+ALT+QCTRL+ALT+Q
切換中斷點Toggle breakpoint F9F9 F9F9
啟用中斷點Enable breakpoint CTRL+F9CTRL+F9 沒有對等項目No equivalent
刪除中斷點。Delete the breakpoint. 只能在 [中斷點] 視窗中使用Only available in the Breakpoints window ALT+F9、DALT+F9, D 沒有對等項目No equivalent
開啟 [編輯中斷點標籤] 對話方塊。Open the Edit breakpoint labels dialog. 只能在 [中斷點] 視窗中使用Only available in the Breakpoints window ALT+F9、LALT+F9, L 沒有對等項目No equivalent
刪除所有中斷點Delete all breakpoints CTRL+SHIFT+F9CTRL+SHIFT+F9 CTRL+SHIFT+F9CTRL+SHIFT+F9
顯示 [中斷點] 視窗Display the Breakpoints window CTRL+ALT+BCTRL+ALT+B CTRL+ALT+BCTRL+ALT+B
全部中斷Break all CTRL+ALT+BREAKCTRL+ALT+BREAK CTRL+ALT+BREAKCTRL+ALT+BREAK
遇到函數時中斷Break at function CTRL+BCTRL+B 沒有對等項目No equivalent
顯示 [監看式 1] 視窗Display the Watch 1 window CTRL+ALT+W、1CTRL+ALT+W, 1 沒有對等項目No equivalent
顯示 [監看式 2] 視窗Display the Watch 2 window CTRL+ALT+W、2CTRL+ALT+W, 2 CTRL+ALT+W、1CTRL+ALT+W, 1
顯示 [監看式 3] 視窗Display the Watch 3 window CTRL+ALT+W、3CTRL+ALT+W, 3 CTRL+ALT+W、3CTRL+ALT+W, 3
顯示 [監看式 4] 視窗Display the Watch 4 window CTRL+ALT+W、4CTRL+ALT+W, 4 CTRL+ALT+W、4CTRL+ALT+W, 4
顯示 [自動變數] 視窗Display the Autos window CTRL+ALT+V、ACTRL+ALT+V, A CTRL+ALT+V、ACTRL+ALT+V, A
顯示 [區域變數] 視窗Display the Locals window CTRL+ALT+V、LCTRL+ALT+V, L CTRL+ALT+V、LCTRL+ALT+V, L
顯示 [即時運算] 視窗Display the Immediate window CTRL+ALT+ICTRL+ALT+I CTRL+ALT+ICTRL+ALT+I
顯示 [呼叫堆疊] 視窗Display the Call Stack window CTRL+ALT+CCTRL+ALT+C CTRL+ALT+CCTRL+ALT+C
顯示 [執行緒] 視窗Display the Threads window CTRL+ALT+HCTRL+ALT+H CTRL+ALT+HCTRL+ALT+H
顯示 [平行堆疊] 視窗。Display the Parallel Stacks window. CTRL+SHIFT+D、SCTRL+SHIFT+D, S 沒有對等項目No equivalent
顯示 [平行工作] 視窗Display the Parallel Tasks window CTRL_SHIFT+D、KCTRL_SHIFT+D, K 沒有對等項目No equivalent

Microsoft IntelliSense 鍵盤快速鍵Microsoft IntelliSense Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
列出成員List members CTRL+JCTRL+J CTRL+SPACECTRL+SPACE

中的多個or

CTRL+JCTRL+J
自動完成文字Complete word CTRL+SPACECTRL+SPACE

中的多個or

ALT+向右鍵ALT+RIGHT ARROW
ALT+向右鍵ALT+RIGHT ARROW
顯示快速資訊Display quick information CTRL+K、CTRL+ICTRL+K, CTRL+I 沒有對等項目No equivalent
顯示參數資訊Display parameter information CTRL+SHIFT+SPACECTRL+SHIFT+SPACE CTRL+SHIFT+SPACECTRL+SHIFT+SPACE
複製參數提示Copy parameter tip CTRL+SHIFT+ALT+CCTRL+SHIFT+ALT+C 沒有對等項目No equivalent
貼上參數提示Paste parameter tip CTRL+SHIFT+ALT+PCTRL+SHIFT+ALT+P 沒有對等項目No equivalent
在語法組之間切換Jump between syntax pairs CTRL+]CTRL+] CTRL+]CTRL+]
啟動程式碼片段選擇器Launch code snippet picker CTRL+K、CTRL+XCTRL+K, CTRL+X CTRL+K、CTRL+ZCTRL+K, CTRL+Z
重新整理本機快取Refresh local cache CTRL+SHIFT+RCTRL+SHIFT+R CTRL+SHIFT+RCTRL+SHIFT+R
啟動範圍陳述式片段選擇器Launch Surround With snippet picker CTRL+K、CTRL+SCTRL+K, CTRL+S CTRL+K、CTRL+SCTRL+K, CTRL+S
顯示程式碼片段管理員Display the Code Snippet Manager CTRL+K、CTRL+BCTRL+K, CTRL+B 沒有對等項目No equivalent
將 IntelliSense 篩選層級從 [通用] 索引標籤變更為 [全部] 索引標籤。Changes the IntelliSense filter level from the Common tab to the All tab. ALT+加號 (+)ALT+PLUS SIGN (+) 沒有對等項目No equivalent
將 IntelliSense 篩選層級從 [全部] 索引標籤變更為 [通用] 索引標籤。Changes the IntelliSense filter level from the All tab to the Common tab. ALT+句號 (.)ALT+PERIOD (.) 沒有對等項目No equivalent

文件視窗和瀏覽器鍵盤快速鍵Document Window and Browser Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
切換全螢幕模式Toggle full-screen mode SHIFT+ALT+ENTERSHIFT+ALT+ENTER SHIFT+ALT+ENTERSHIFT+ALT+ENTER
移到文件分割窗格檢視的下一個窗格Move to the next pane of a split pane view of a document F6F6 F6F6
移到編輯器或設計師中的上一份文件Move to the previous document in the editor or designer CTRL+SHIFT+F6CTRL+SHIFT+F6

CTRL+SHIFT+TABCTRL+SHIFT+TAB
CTRL+SHIFT+F6CTRL+SHIFT+F6

CTRL+SHIFT+TABCTRL+SHIFT+TAB
移到分割窗格檢視中的上一個文件窗格Move to the previous pane of a document in split pane view SHIFT+F6SHIFT+F6 SHIFT+F6SHIFT+F6
上一頁,顯示在檢視記錄中的上一頁Back, display the previous page in the viewing history ALT+向左鍵ALT+LEFTARROW ALT+向左鍵ALT+LEFTARROW
下一頁,顯示在檢視記錄中的下一頁Forward, display the next page in the viewing history ALT+向右鍵ALT+RIGHTARROW ALT+向右鍵ALT+RIGHTARROW
關閉功能表或對話方塊、取消正在進行中的操作,或者將焦點放在目前的視窗Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window ESCESC 沒有對等項目No equivalent

方案總管鍵盤快速鍵Solution Explorer Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
顯示方案總管Display Solution Explorer CTRL+ALT+LCTRL+ALT+L CTRL+ALT+LCTRL+ALT+L
顯示 [新增檔案] 對話方塊來建立新檔案Display the New File dialog box to create a new file CTRL+NCTRL+N CTRL+NCTRL+N
顯示 [新增專案] 對話方塊來建立新專案Display the New Project dialog box to create a new project CTRL+SHIFT+NCTRL+SHIFT+N CTRL+SHIFT+NCTRL+SHIFT+N
顯示 [開啟檔案] 對話方塊來開啟現有的檔案Display the Open File dialog box to open an existing file CTRL+OCTRL+O CTRL+OCTRL+O
變更選定物件的名稱Change the name of the selected object F2F2 沒有對等項目No equivalent

說明和線上叢書鍵盤快速鍵Help and Books Online Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
說明Help F1F1

中的多個or

SHIFT+F1SHIFT+F1
F1F1
顯示 SQL Server 線上叢書Display SQL Server Books Online CTRL+F1CTRL+F1 沒有對等項目No equivalent
開啟 Help Library 管理員Open the Help Library Manager CTRL+ALT+F1CTRL+ALT+F1 沒有對等項目No equivalent
顯示 SQL Server 資源中心網頁Display the SQL Server Resource Center Web page CTRL+ALT+F2CTRL+ALT+F2 沒有對等項目No equivalent
顯示目前編輯器視窗的説明Display help for the current editor window SHIFT+F1SHIFT+F1 沒有對等項目No equivalent
「如何」的說明Help on "How Do I" 沒有對等項目No equivalent CTRL+F1CTRL+F1
線上叢書內容Books Online Contents 沒有對等項目No equivalent CTRL+ALT+F1CTRL+ALT+F1
線上叢書索引Books Online Index 沒有對等項目No equivalent CTRL+ALT+F2CTRL+ALT+F2
說明搜尋Help Search 沒有對等項目No equivalent CTRL+ALT+F3CTRL+ALT+F3
動態說明Dynamic Help 沒有對等項目No equivalent CTRL+ALT+F4CTRL+ALT+F4
最愛說明Help Favorites 沒有對等項目No equivalent CTRL+ALT+FCTRL+ALT+F

搜尋鍵盤快速鍵Search Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
顯示 [尋找] 對話方塊Display the Find dialog box CTRL+FCTRL+F CTRL+FCTRL+F
顯示 [尋找] 對話方塊的 [檔案中尋找] 索引標籤。Displays the In Files tab of the Find dialog box.
顯示選定符號的定義。Displays the definition for the selected symbol. F12F12 沒有對等項目No equivalent
顯示選定符號的參考清單。Displays the list of references for the selected symbol. SHIFT+F12SHIFT+F12 沒有對等項目No equivalent
顯示 [取代] 對話方塊Display the Replace dialog box CTRL+HCTRL+H CTRL+HCTRL+H
啟動累加搜尋。Start incremental search. 請輸入要搜尋的字元,或按 CTRL+I 鍵來搜尋上一次搜尋中的字元Type the characters to search for or press CTRL+I to search for characters from the previous search CTRL+ICTRL+I CTRL+ICTRL+I
尋找上一個搜尋文字的下一個出現項目Find the next occurrence of the previous search text F3F3 F3F3
尋找搜尋文字的上一個出現項目Find the previous occurrence of the search text SHIFT+F3SHIFT+F3 SHIFT+F3SHIFT+F3
尋找目前選取之文字的下一個出現項目Find the next occurrence of the currently selected text CTRL+F3CTRL+F3 CTRL+F3CTRL+F3
尋找目前選取之文字的上一個出現項目Find the previous occurrence of the currently selected text CTRL+SHIFT+F3CTRL+SHIFT+F3 CTRL+SHIFT+F3CTRL+SHIFT+F3
顯示 [檔案中取代] 對話方塊Display the Replace in Files dialog box CTRL+SHIFT+HCTRL+SHIFT+H CTRL+SHIFT+HCTRL+SHIFT+H
反向累加搜尋,使它從檔案底端開始,向上搜尋到頂端Reverse incremental search so it starts at the bottom of the file and searches to the top CTRL+SHIFT+ICTRL+SHIFT+I CTRL+SHIFT+ICTRL+SHIFT+I
選取或清除 [尋找和取代] 中的 [向上搜尋] 選項Select or clear the Search up option in Find and Replace ALT+F3、BALT+F3, B ALT+F3、BALT+F3, B
停止 [檔案中尋找] 的搜尋動作Stop the Find in Files search ALT+F3、SALT+F3, S ALT+F3、SALT+F3, S
選取或清除 [尋找和取代] 中的 [全字拼寫須相符] 選項Select or clear the Find whole word option in Find and Replace ALT+F3、WALT+F3, W ALT+F3、WALT+F3, W
選取或清除 [尋找和取代] 中的 [萬用字元] 選項Selects or clears the Wildcard option in Find and Replace ALT+F3、PALT+F3, P ALT+F3、PALT+F3, P
將插入號放在標準工具列的 [尋找]/[命令] 方塊中Place the caret in the Find/Command box of the Standard toolbar CTRL+/CTRL+/ 沒有對等項目No equivalent

剪下和貼上鍵盤快速鍵Cut and Paste Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
剪下 (刪除目前選取的項目,並將它放在剪貼簿中)Cut (delete the currently selected item and place it to the Clipboard) CTRL+XCTRL+X

中的多個or

SHIFT+ALT++DELETESHIFTRLT+DELETE
CTRL+XCTRL+X

中的多個or

SHIFT+DELETESHIFT+DELETE
剪下所有選取的行或是目前這一行 (如果未選取任何項目)。Cuts all of the selected lines, or the current line if nothing is selected. CTRL+LCTRL+L

中的多個or

CTRL+SHIFT+LCTRL+SHIFT+L
沒有對等項目No equivalent
複製到剪貼簿Copy to the Clipboard CTRL+CCTRL+C

中的多個or

CTRL+INSERTCTRL+INSERT
CTRL+CCTRL+C

中的多個or

CTRL+INSERTCTRL+INSERT
從剪貼簿貼到插入點Paste from the Clipboard at the insertion point CTRL+VCTRL+V

中的多個or

SHIFT+INSERTSHIFT+INSERT
CTRL+VCTRL+V

中的多個or

SHIFT+INSERTSHIFT+INSERT
從剪貼環的插入點貼上項目,並自動選取貼上的項目Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item CTRL+SHIFT+VCTRL+SHIFT+V

中的多個or

CTRL+SHIFT+INSERTCTRL+enseSHIFT+INSERT
沒有對等項目No equivalent

記錄檢視器鍵盤快速鍵Log Viewer Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
重新整理Refresh 沒有對等項目No equivalent F5F5
在 [選取記錄] 窗格和 [記錄檔摘要] 窗格之間移動Move between the Select logs pane and the Log file summary pane 沒有對等項目No equivalent F6F6
移到 [記錄檔摘要] 窗格Move to the Log file summary pane 沒有對等項目No equivalent ALT+SALT+S
載入新記錄Load a new log 沒有對等項目No equivalent CTRL+SHIFT+LCTRL+SHIFT+L
匯出記錄Export a log 沒有對等項目No equivalent CTRL+SHIFT+ECTRL+SHIFT+E
篩選記錄Filter a log 沒有對等項目No equivalent CTRL+SHIFT+FCTRL+SHIFT+F
在記錄中搜尋Search in a log 沒有對等項目No equivalent CTRL+SHIFT+SCTRL+SHIFT+S

活動監視器鍵盤快速鍵Activity Monitor Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
啟動 [活動監視器]Launches Activity Monitor CTRLl+ALT+ACTRLl+ALT+A CTRLl+ALT+ACTRLl+ALT+A
關閉 [活動監視器]Closes Activity Monitor CTRL+F4CTRL+F4 CTRL+F4CTRL+F4
重新整理Refresh F5F5 F5F5
篩選監視器顯示畫面Filter the monitor display CTRL+SHIFT+FCTRL+SHIFT+F CTRL+SHIFT+FCTRL+SHIFT+F
轉換面板Cycle through panels F6F6 F6F6
展開或折疊選取的窗格Expand or collapse selected pane CTRL 和 + 或 -CTRL and + or - CTRL 和 + 或 -CTRL and + or -
展開或折疊所有窗格Expand or collapse all panes + 或 -+ or - + 或 -+ or -
複製方格中選取的整個資料列Copies entire selected row in grid CTRL+CCTRL+C CTRL+CCTRL+C
複製資料格Copy cell CTRL+SHIFT+CCTRL+SHIFT+C CTRL+SHIFT+CCTRL+SHIFT+C
在方格中下拉以篩選Drop-down for filtering in grid ALT+DOWNALT+DOWN ALT+DOWNALT+DOWN
向上或向下捲動 [活動監視器]Scroll up or down Activity Monitor CTRL+ALT+UP/DOWNCTRL+ALT+UP/DOWN CTRL+ALT+UP/DOWNCTRL+ALT+UP/DOWN

複寫監視器鍵盤快速鍵Replication Monitor Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
重新整理Refresh F5F5 F5F5
從方格開啟詳細資料視窗Open a detail window from a grid ENTERENTER ENTERENTER

複寫衝突檢視器鍵盤快速鍵Replication Conflict Viewer Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
定義篩選Define filter F6F6 F6F6
套用篩選Apply filter F7F7 F7F7
顯示所有資料行Show all columns F8F8 F8F8

查詢設計工具鍵盤快速鍵Query Designer Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
取消或停止目前正在執行的查詢Cancels or stops the currently running query CTRL+TCTRL+T CTRL+TCTRL+T
顯示 [查詢設計工具] 的圖表窗格Displays the diagram pane of the Query Designer CTRL+1CTRL+1 CTRL+1CTRL+1
顯示 [查詢設計工具] 的準則窗格Displays the criteria pane of the Query Designer CTRL+2CTRL+2 CTRL+2CTRL+2
顯示 [查詢設計工具] 的 SQL 窗格Displays the SQL pane of the Query Designer CTRL+3CTRL+3 CTRL+3CTRL+3
顯示 [查詢設計工具] 的結果窗格Displays the results pane of the Query Designer CTRL+4CTRL+4 CTRL+4CTRL+4
執行 [查詢設計工具] 中指定的查詢Run the query specified in the Query Designer CTRL+RCTRL+R CTRL+RCTRL+R
在結果窗格中,將焦點移到設計工具底部停駐的工具帶When in the results pane, moves focus to the tool strip docked at the bottom of the designer CTRL+GCTRL+G CTRL+GCTRL+G
在 [查詢設計工具] 中啟用 JOIN 模式Enables JOIN mode in the Query Designer CTRL+SHIFT+JCTRL+SHIFT+J CTRL+SHIFT+JCTRL+SHIFT+J

設計工具鍵盤快速鍵Designer Keyboard Shortcuts

動作Action SQL Server 2017SQL Server 2017 SQL Server 2008 R2SQL Server 2008 R2
在設計介面上以 8 為增量將選取的控制項往下移動Move the selected control down in increments of 8 on the design surface DOWN ARROWDOWN ARROW 沒有對等項目No equivalent
在設計介面上以 8 為增量將選取的控制項往左移動Move the selected control left in increments of 8 on the design surface 向左鍵LEFT ARROW 沒有對等項目No equivalent
在設計介面上以 8 為增量將選取的控制項往右移動Move the selected control right in increments of 8 on the design surface 向右鍵RIGHT ARROW 沒有對等項目No equivalent
在設計介面上以 8 為增量將選取的控制項往上移動Move the selected control up in increments of 8 on the design surface 向上鍵UP ARROW 沒有對等項目No equivalent
以 8 為增量來增加選定控制項的高度Increases the height of the selected control in increments of 8 SHIFT+向下鍵SHIFT+DOWN ARROW 沒有對等項目No equivalent
以 8 為增量來減少選定控制項的寬度Reduces the width of the selected control in increments of 8 SHIFT+向左鍵SHIFT+LEFT ARROW 沒有對等項目No equivalent
以 8 為增量來增加選定控制項的寬度Increases the width of the selected control in increments of 8 SHIFT+向右鍵SHIFT+RIGHT ARROW 沒有對等項目No equivalent
以 8 為增量來減少選定控制項的高度Decreases the height of the selected control in increments of 8 SHIFT+向上鍵SHIFT+UP ARROW 沒有對等項目No equivalent
移到頁面上的下一個控制項Moves to the next control on the page TABTAB 沒有對等項目No equivalent
移到頁面上的上一個控制項Moves to the previous control on the page SHIFT+TABSHIFT+TAB 沒有對等項目No equivalent
在設計介面上顯示方格Display the grid on the design surface ENTERENTER 沒有對等項目No equivalent

另請參閱See Also

自訂功能表與快速鍵Customize Menus and Shortcut Keys