quote:

---

Keyboard Shortcuts
The following Microsoft® SQL Server™ tools have keyboard shortcuts:

Data Mining Model Browser

Keyboard Shortcuts (Data Mining Model Browser)
This table describes the keyboard shortcuts available in Data Mining Model Browser. You can use shortcuts to access all parts of the browser except the content navigator pane.

Some sections support additional shortcuts. After a section has focus, you can use shortcuts to navigate within the section.

Activity Shortcut
Move the focus to the next item. Navigation progression moves from the top left towards the bottom right of the screen.
You can use the TAB key to access the prediction tree, content detail pane, attributes pane, node path, attribute shading list and Help.

When the focus is on the content detail pane, you can use arrow keys to navigate the model.
TAB (SHIFT+ TAB for reverse order)
Toggle the focus between the content detail and attributes panes. F6
When the focus is on the content detail pane, right-click in the pane to access the Zoom In and Zoom Out menu commands. SHIFT+F10
Zoom out, when focus is on the content detail pane. CTRL+ -
Zoom in, when focus is on the content detail. CTRL+ +
Move the focus to the prediction tree pane, and then use arrow keys to navigate the list and the ENTER key to select a different value. ALT+ P
Move the focus to the attribute shading list, and then use arrow keys to navigate the list and the ENTER key to select a different value. ALT+ O
Move the focus to the node path pane, and then use arrow keys to navigate the text. ALT+ D
Move the focus to the attributes pane, and then use the arrow keys to navigate between the Totals and Histograms tabs and to scroll tab contents. ALT+ U
Copy text, when the focus is on an attribute. CTRL+ C
Select all, when the focus is on attributes. CTRL+ A
Open Help. ALT+ H



See Also

Content Detail Pane (Data Mining Model Browser)

Content Navigator Pane (Data Mining Model Browser)

Viewing with Data Mining Model Browser

Data Mining Model Browser


Dependency Network Browser

Keyboard Shortcuts (Dependency Network Browser)
This table describes the keyboard shortcuts available in Dependency Network Browser. These shortcuts correspond to toolbar buttons. For more information about the tools, see Toolbar (Dependency Network Browser).

Toolbar button Shortcut
Zoom In CTRL- +
Zoom Out CTRL- -
Zoom To Fit ALT- F
Improve Layout ALT- L
Find CTRL- F



See Also

Viewing with Dependency Network Browser

Dependency Network Browser


English Query

Shortcut Keys Used in English Query
This topic describes the shortcut keys used in English Query.

Global Keys
Use these shortcut keys in all English Query windows.

Shortcut keys Description
CTRL+N Opens a new project.
CTRL+O Opens an existing project.
CTRL+SHIFT+N Opens a new file.
CTRL+SHIFT+O Opens an existing file.
CTRL+SHIFT+S Saves all modules and the project.
F1 Displays Help.
LEFT ARROW
UP ARROW Selects the previous item in a combo box.
RIGHT ARROW
DOWN ARROW Selects the next item in a combo box.


For more information about shortcut keys, see the Microsoft® Visual Studio® documentation.

Menu Keys
Use these keys to navigate the Menu bar.

Shortcut keys Description
LEFT Selects the next menu.
RIGHT Selects the previous menu.
UP Selects the previous item in a menu.
DOWN Selects the next item in a menu or expand menu.
ESC Clears menus.


Model Editor: Navigation Keys
Use these keys to navigate the hierarchical panes and tabs of the Model Editor.



Note These shortcut keys do not work in the Canvas pane.


Shortcut keys Description
CTRL+PAGE UP Selects the next tab.
CTRL+PAGE DOWN Selects the previous tab.
UP Selects the previous item in the tree.
DOWN Selects the next item in the tree.
RIGHT Expands current item in the tree.
LEFT Collapses current item in the tree if expanded. Otherwise, selects parent item in the tree.


Model Editor: Editing Keys
Use these keys to edit objects in the hierarchical pane of the Model Editor.

Shortcut keys Description
ENTER
Double-click an entity or relationship. Displays a dialog box in which you can edit the currently selected object in the tree.
CTRL+C Copies the selected object or objects and places them on the Clipboard.
CTRL+V Pastes the object or objects.
CTRL+X Cuts the selected object or objects and place them on the Clipboard.
DELETE Deletes the selected object or objects.
CTRL+Click Selects multiple objects.


Canvas Pane Keys
Use these shortcut keys in the Canvas pane.

Shortcut keys Description
BACKSPACE Cancels any selection.
TAB Selects the next object.
SPACEBAR Starts auto layout.
Stops the layout process in animation mode.
DELETE Removes the selected object from the Canvas pane.
UP ARROW
PAGE UP Moves the Canvas pane up.
DOWN ARROW
PAGE DOWN Moves the Canvas pane down.
LEFT ARROW
HOME Moves the Canvas pane to the left.
RIGHT ARROW
END Moves the Canvas pane to the right.
CTRL+A Selects all of the objects in the Canvas pane.
CTRL+F Displays the Find dialog box.


Project Wizard Keys
Use these shortcut keys in the SQL Project and OLAP Project wizards.

Shortcut keys Description
SPACEBAR Selects or clears the check boxes.
TAB Move the focus through the various elements. If the relationships are expanded, TAB also moves the focus among the elements.
ENTER Runs the Project Wizard and closes the window. Expands any item with a plus sign (+) and collapses an item with a minus sign (-).


Model Test Window Keys
Use these shortcut keys in the Model Test window.

Shortcut keys Description
ENTER Runs the query.
CTRL+BREAK Stops the query.
CTRL+S Saves the query in a regression file.
CTRL+R Displays or hides the query results.
CTRL+W Runs the Suggestion Wizard that helps define entities and relationships to answer a question that currently does not work.
CTRL+T Displays the Test Properties dialog box
CTRL+PAGE UP Selects the next tab in the Model Test window.
CTRL+PAGE DOWN Selects the previous tab in the Model Test window.


Command Tab (Relationship/New Relationship Dialog Box)
Use these shortcut keys on the Command tab of the Relationship/New Relationship dialog box.

Shortcut keys Description
ALT+P Moves the focus to the grid.
CTRL+SPACEBAR Selects the current row.
DELETE Deletes the selected row.
INSERT Inserts a row above the selected row.
UP and DOWN ARROWS Selects the preceding and following item.
SPACEBAR Activates the cell and selects the item.
TAB Moves the focus to the next element in the tab.


Default Relationships Dialog Box
Use these shortcut keys in the Default Relationships dialog box.



Note You can make only contiguous selections using the keyboard. To make noncontiguous selections, press CTRL and click the rows you want to select.


Shortcut keys Description
CTRL+SPACEBAR Selects the current row.
DELETE Deletes the selected row.
INSERT Inserts a row above the selected row.
RIGHT, LEFT, UP, and DOWN ARROWS Selects the item to the right, left, up, and down of the currently selected item.
SHIFT+DOWN ARROW Selects the next row to make a contiguous selection.
SHIFT+UP ARROW Selects the previous row to make a contiguous selection.
SPACEBAR Activates the cell and selects the item.
TAB Moves the focus to the next element in the tab.


Entity/New Entity Dialog Box
Use these keys in the Entity/New Entity dialog box.

Shortcut keys Description
SPACEBAR When the Words list has the focus, displays the words so you can view or edit them.
When editing the Words list, moves a selected item between Selected Fields and Available Fields.

When the Display Field(s) or the Fields(s) list has the focus, displays the Selected Fields and Available Fields lists so that you can view and edit them.

When editing the Selected Fields and Available Fields lists, moves the selected item from one list to the other.

Comma (,) or DOWN ARROW Moves the pointer to the next line when entering data in the Words list.
UP and DOWN ARROWS Selects the previous or next item in the Words, synonym, and Display Field(s) lists.
ENTER Closes a list.


Regression Differences Dialog Box Keys
Use these keys in the Regression Differences dialog box.

Shortcut keys Description
ALT+F3 Displays the Find dialog box where you specify the text you are trying to find.
F3 In the active pane, finds and selects the next occurrence of the text specified in the Find What box of the Find dialog box.
SHIFT+F3 In the active pane, finds and selects the previous occurrence of the text that is specified in the Find What box of the Find dialog box.
SHIFT+F7 Finds and moves the to the beginning of the previous text that has differences.
F7 Finds and moves the to the beginning of the next text that has differences.


Table/New Table Dialog Box Keys
Use these keys to make changes in the Table/New Table dialog box.



Note You can make only contiguous selections using the keyboard. To make noncontiguous selections, press CTRL and click the rows you want to select.


Shortcut keys Description
CTRL+K Makes the field of the selected row a primary key.
CTRL+SPACEBAR Selects the current row.
DELETE Deletes the selected row.
INSERT Inserts a row above the selected row.
RIGHT, LEFT, UP, and DOWN ARROWS Selects the item to the right, left, up, and down from the item in the selected box.
SHIFT+DOWN ARROW Selects the next row so you can make a contiguous selection.
SHIFT+UP ARROW Selects the previous row so you can make a contiguous selection.


List Keys
Use these shortcut keys in any list. A list is any type of box that contains a list of items from which you can select.

Keys Descriptions
UP and RIGHT ARROW Selects the next item in the list. If there is more than one column, RIGHT ARROW selects the item in the next column. Not available in all lists.
DOWN and LEFT ARROW Selects the previous item in the list. If there is more than one column, LEFT ARROW selects the item in the previous column. Not available in all lists.
CTRL+SPACEBAR Opens the list and displays all of the items.


Editable List Keys
Use these shortcut keys in any editable list. An editable list consists of a rectangular box in which you can type text. If the list already contains items, you can select that default text or delete it and type new text.

Keys Description
SPACEBAR Displays the list and selects the first empty cell.
When a cell with an item has the focus, also selects the text so that it can be edited.

ENTER Accepts the changes and closes the list.
Comma (,) or DOWN ARROW Moves the cursor to the next line when editing data.
UP and DOWN ARROWS Select the previous or next line in the list.


Select Box Keys
Use these shortcut keys in any select box with Selected and Available Fields columns in which you move an item from one column to the other.

Keys Description
SPACEBAR When the select box has the focus, displays the Selected Fields and Available Fields list so that you can view and edit the lists.
When editing the lists, moves the selected item from the current list to the other list.

ENTER Accepts the selection and closes the list.
RIGHT and LEFT ARROWS Select the item in the column to the right or the left of the selected item.
UP and DOWN ARROWS Select the item prior to or after the selected item.



See Also

Add/Edit Entity Default Dialog Box

Adjective Phrasing Dialog Box

Command Phrasing Dialog Box

Data Connection Tab (Project Properties Dialog Box)

Database Tab (Relationship/New Relationship Dialog Box)

Default Relationships Tab (Project Properties Dialog Box)

English Data Values Dialog Box

English Tab (Project Properties Dialog Box)

Entity/New Entity Dialog Box

Find Dialog Box

Name/ID Phrasing Dialog Box

New Dictionary Entry Dialog Box

OLAP Cube Dialog Box

OLAP Dimension Dialog Box

OLAP Tab (Model Editor)

Preposition Phrasing Dialog Box

Regression Differences Dialog Box

Semantic Properties Tab (Advanced Entity Properties Dialog Box)

Semantics Tab (Model Editor)

Semantics Tab (Relationship/New Relationship Dialog Box)

SQL Tab (Model Editor)

Subset Phrasing Dialog Box

Table/New Table Dialog Box

Test Properties Dialog Box

Trait Phrasing Dialog Box

Verb Phrasing Dialog Box


Query Designer

Navigating in the Query Designer
You can work in the Query Designer using the keyboard or the mouse. Refer to the following tables for specific methods.

Any Pane
To Press Click
Move among the Query Designer panes F6, SHIFT+F6 Anywhere in the target pane


Diagram Pane
To Press Click
Move among tables, other table-structured objects, (and to join lines, if available) TAB, or SHIFT+TAB The table, table-structured object, or join line to move to
Move between columns in a table or table-structured object Arrow keys The column to go to
Choose the selected data column for output SPACEBAR1 or
PLUS key The check box next to the name of the column
Remove the selected data column from the query output SPACEBAR1 or
MINUS key The check box next to the name of the column
Remove the selected table, table-structured object, or join line from the query DELETE Right-click, and then choose Remove


1 If multiple items are selected, pressing this key affects all selected items. Select multiple items by holding down the SHIFT key while clicking them. Toggle the selected state of a single item by holding down CTRL while clicking it.

Grid Pane
To Press Click
Move among cells Arrow keys or TAB or SHIFT+TAB The target cell
Move to the last row in the current column CTRL+DOWN ARROW
Move to the first row in the current column CTRL+UP ARROW
Move to the top left cell in the visible portion of grid CTRL+HOME
Move to the bottom right cell CTRL+END
Move in a drop-down list UP ARROW or DOWN ARROW The button in the cell
Select an entire grid column CTRL+SPACEBAR The column header
Select an entire grid row The button to the left of the row
Toggle between edit mode and cell selection mode F2
Copy selected text in cell to the Clipboard (in edit mode) CTRL+C
Cut selected text in cell and place it on the Clipboard (in edit mode) CTRL+X
Paste text from the Clipboard (in edit mode) CTRL+V
Toggle between insert and overstrike mode while editing in a cell INS
Toggle the check box in the Output column SPACEBAR1 The check box
Clear the selected contents of a cell DELETE
Remove row containing selected data column from the query DELETE1
Clear all values for a selected grid column DELETE
Insert row between existing rows INS after you select grid row
Add an Or ... column INS after you select any Or ... column


1 If multiple items are selected, pressing this key affects all selected items.

SQL Pane
You can use the standard Windows editing keys when working in the SQL pane, such as CTRL+Arrow keys to move between words, and the Cut, Copy, and Paste commands on the Edit menu.

Note You can only insert text; there is no overstrike mode.

Results Pane
To Press Click
Move between cells Arrow keys or TAB or SHIFT+TAB The target cell
Move to first or last cell in current row HOME or END
Move to the first row in the current column CTRL+UP ARROW
Move to the top left cell CTRL+HOME
Move to the bottom cell in the first column CTRL+DOWN ARROW
Select to first character in a cell SHIFT+HOME
Select to last character in a cell SHIFT+END
Select an entire grid column CTRL+SPACEBAR The column header
Select an entire grid row The button to the left of the row
Toggle between edit mode and cell selection mode F2
Toggle between insert and overstrike mode while editing in a cell INS
Insert a new row into the grid (moves to last row in grid) INS while cell is selected
Delete a row from the table DELETE1
Undo changes for the current cell ESC in cell that has changed
Undo changes for the current row ESC in any cell that has not changed
Enter null into a cell CTRL+0
Copy selected columns or rows to the Clipboard CTRL+C
Copy selected text in cell to the Clipboard (in edit mode) CTRL+C
Cut selected text in cell to the Clipboard (in edit mode) CTRL+X
Paste text from the Clipboard (in edit mode) CTRL+V


1 If multiple items are selected, pressing this key affects all selected items.

See Also
Reference


SQL Profiler

SQL Profiler Keyboard Shortcuts
The following table shows the keyboard shortcuts available in SQL Profiler.

CTRL+Shift+Delete Clear a trace window
CTRL+F4 Close a trace window
- Collapse a trace grouping
CTRL+C Copy
ALT+Delete Delete a trace
+ Expand a trace grouping
CTRL+F Find
F3 Find the next item
Shift+F3 Find the previous item
F1 Display available help
CTRL+N Open a new trace
ALT+F7 Replay the settings
CTRL+F10 Run to cursor
F5 Start a replay
F11 Step
Shift+F5 Stop a replay
F9 Toggle a breakpoint



SQL Query Analyzer

SQL Query Analyzer Keyboard Shortcuts
This table displays the keyboard shortcuts available in SQL Query Analyzer.

Activity Shortcut
Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2
Bookmarks: Insert or remove a bookmark (toggle). CTRL+F2
Bookmarks: Move to next bookmark. F2
Bookmarks: Move to previous bookmark. SHIFT+F2
Cancel a query. ALT+BREAK
Connections: Connect. CTRL+O
Connections: Disconnect. CTRL+F4
Connections: Disconnect and close child window. CTRL+F4
Database object information. ALT+F1
Editing: Clear the active Editor pane. CTRL+SHIFT+DEL
Editing: Comment out code. CTRL+SHIFT+C
Editing: Copy. You can also use CTRL+INSERT. CTRL+C
Editing: Cut. You can also use SHIFT+DEL. CTRL+X
Editing: Decrease indent. SHIFT+TAB
Editing: Delete through the end of a line in the Editor pane. CTRL+DEL
Editing: Find. CTRL+F
Editing: Go to a line number. CTRL+G
Editing: Increase indent. TAB
Editing: Make selection lowercase. CTRL+SHIFT+L
Editing: Make selection uppercase. CTRL+SHIFT+U
Editing: Paste. You can also use SHIFT+INSERT. CTRL+V
Editing: Remove comments. CTRL+SHIFT+R
Editing: Repeat last search or find next. F3
Editing: Replace. CTRL+H
Editing: Select all. CTRL+A
Editing: Undo. CTRL+Z
Execute a query. You can also use CTRL+E (for backward compatibility). F5
Help for SQL Query Analyzer. F1
Help for the selected Transact-SQL statement. SHIFT+F1
Navigation: Switch between query and result panes. F6
Navigation: Switch panes. Shift+F6
Navigation: Window Selector. CTRL+W
New Query window. CTRL+N
Object Browser (show/hide). F8
Object Search. F4
Parse the query and check syntax. CTRL+F5
Print. CTRL+P
Results: Display results in grid format. CTRL+D
Results: Display results in text format. CTRL+T
Results: Move the splitter. CTRL+B
Results: Save results to file. CTRL+SHIFT+F
Results: Show Results pane (toggle). CTRL+R
Save. CTRL+S
Templates: Insert a template. CTRL+SHIFT+INSERT
Templates: Replace template parameters. CTRL+SHIFT+M
Tuning: Display estimated execution plan. CTRL+L
Tuning: Display execution plan (toggle ON/OFF). CTRL+K
Tuning: Index Tuning Wizard. CTRL+I
Tuning: Show client statistics CTRL+SHIFT+S
Tuning: Show server trace. CTRL+SHIFT+T
Use database. CTRL+U



SQL Server Books Online also has keyboard shortcuts:

Using Accessibility Features in SQL Server Books Online

Using Accessibility Features in SQL Server Books Online
The following topics describe the accessibility features that can be used for navigating SQL Server Books Online.

For more information about accessibility features and services, see the Accessibility page at Microsoft Web site.

Changing the Appearance of the Text
The formatting, font, and color of the text in SQL Server Books Online can be changed.

To change formatting or styles for accessibility

On the Options menu, click Internet Options, and then click Accessibility.


In the Accessibility dialog box, select the options you want, and then click OK.
These changes do not apply to the Navigation pane or toolbar of SQL Server Books Online. This procedure also changes your accessibility settings for Microsoft® Internet Explorer.

To change the font size of a topic

On the Options menu, click Internet Options, and then click Fonts.
These changes do not apply to the Navigation pane or toolbar of SQL Server Books Online. This procedure also changes your font settings for Internet Explorer.

To change colors in the Topic pane of SQL Server Books Online

In Microsoft Internet Explorer 5.0, on the Tools menu, click Internet Options.


On the General tab, click Colors.


In the Colors dialog box, select the options you want, and then click OK.


To apply the new color settings, in the Internet Options dialog box, click OK.
These changes do not apply to the Navigation pane or toolbar of SQL Server Books Online. This procedure also changes your color settings for Internet Explorer.

Using Keyboard Shortcuts
The following tables show the keyboard shortcuts that can be used for navigating SQL Server Books Online.

SQL Server Books Online
To Press
Close SQL Server Books Online. ALT+F4
Switch between SQL Server Books Online and other open windows. ALT+TAB
Display the Options menu. ALT+O
Change Microsoft® Internet Explorer settings. The Internet Options dialog box contains accessibility settings. To change these settings, click the General tab, and then click Accessibility. ALT+O, and then press I
Hide or show the Navigation pane. ALT+O, and then press T
Print a topic. ALT+O, and then press P
Move back to the previous topic. ALT+LEFT ARROW, or ALT+O, and then press B
Move forward to the next topic (provided you have just previously viewed it). ALT+RIGHT ARROW, or ALT+O, and then press F
Turn on or off search highlighting. ALT+O, and then press O
Switch between the Navigation pane and the Topic pane. F6
Scroll through the table of contents, displaying each topic as you scroll. ALT+UP ARROW, or ALT+DOWN ARROW
Scroll through a topic. UP ARROW and DOWN ARROW, or PAGE UP and PAGE DOWN
Scroll through all the links in a topic or through all the options on a Navigation pane tab. TAB
Display the Documentation Feedback form. SHIFT+CTRL+F
Display the topic containing keyboard shortcuts. SHIFT+CTRL+K
Display the See Also topics for a particular topic. SHIFT+CTRL+S


Contents Tab
To Press
Display the Contents tab. ALT+C
Open and close a book or folder. PLUS SIGN and MINUS SIGN, or LEFT ARROW and RIGHT ARROW
Select a topic. DOWN ARROW and UP ARROW
Display the selected topic. ENTER


Index Tab
To Press
Display the Index tab. ALT+N
Type a keyword to search for. ALT+W, and then type the word
Select a keyword in the list. UP ARROW and DOWN ARROW
Display the associated topic. ALT+D


Search Tab
To Press
Display the Search tab. ALT+S
Type a keyword to search for. ALT+W, and then type the word
Start a search. ALT+L
Select a topic in the results list. ALT+T, and then UP ARROW and DOWN ARROW
Display the selected topic. ALT+D
Search for a word or phrase in a topic. CTRL+F
Search for a keyword in the result list of a prior search. ALT+U
Search for words similar to the keyword. For example, to find words such as "running" and "runs" for the keyword "run." ALT+M
Search only through topic titles. ALT+R


Favorites Tab
To Press
Display the Favorites tab. ALT+I
Add the currently displayed topic to the Favorites list. ALT+A
Select a topic in the Favorites list. ALT+P, and then UP ARROW and DOWN ARROW
Display the selected topic. ALT+D
Remove the selected topic from the list. ALT+R



©1988-2000 Microsoft Corporation. All Rights Reserved.

---