Navigate in the Query and View Designer (Visual Database Tools)

Applies to: SQL Server

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

Any Pane

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

Tip

You can use the shortcut keys CTRL+TAB to change focus to other panes in addition to the Query and View Designer panes.

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 SPACEBAR or PLUS key The check box next to the name of the column
Remove the selected data column from the query output SPACEBAR 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

Note

If multiple items are selected, pressing this key affects all selected items. Select multiple items by holding down the CTRL key while clicking them.

For more information, see Diagram Pane (Visual Database Tools).

Criteria Pane

To Press Click
Move among cells Arrow keys or TAB or SHIFT+TAB The target cell
Move to the last row in a selected column CTRL+DOWN ARROW
Move to the first row in a selected 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
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 SPACEBAR The check box
Clear the selected contents of a cell DELETE
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

Note

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

For more information, see Criteria Pane (Visual Database Tools).

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.

For more information, see SQL Pane (Visual Database Tools).

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
Toggle between edit mode and cell selection mode F2
Toggle between insert and overstrike mode while editing in a cell INS
Delete a row from the table DELETE
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

Note

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

For more information, see Results Pane (Visual Database Tools).

See Also

Design Queries and Views How-to Topics (Visual Database Tools)