Help Center> GaussDB(DWS)> Tool Guide> Data Studio - Integrated Database Development Tool> Personalizing Data Studio> General
Updated on 2023-04-03 GMT+08:00
View PDF

General

This section provides details on how to customize shortcut keys.

Setting the Shortcut Keys

You can customize the Data Studio shortcut keys as required.

Follow the steps below to set or modify the shortcut keys:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose General > Shortcut Mapper.

    The Shortcut Mapper pane is displayed.

  3. Select the required shortcut key and click Modify.
  4. Enter the required shortcut key in the Binding text box.

    For example, to change the shortcut key for Step Into from F7 to F6, enter F6 in the Binding text box.

  5. Click OK. The Restart Data Studio dialog box is displayed.

    Multiple shortcut keys can be modified before restarting Data Studio.

  6. Click Yes to restart Data Studio. If any export, import or execution operations are in progress, then the Restart Confirmation dialog box is displayed.
  7. Click OK to close running jobs and restart or click Cancel to abort restart operation.

Follow the steps below to remove the shortcut keys:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose General > Shortcut Mapper.

    The Shortcut Mapper pane is displayed.

  3. Select the required shortcut key and click Unbind Key.
  4. Click Ok. The Restart Data Studio window is displayed.

    Multiple shortcut keys can be removed before restarting Data Studio.

  5. Click Yes to restart Data Studio. If any export, import or execution operations are in progress, then the Process is running dialog box is displayed.
  6. Click OK to wait for operations to complete or click Force Restart to discard operations.

Follow the steps below to restore the default shortcut keys:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose General > Shortcut Mapper.

    The Shortcut Mapper pane is displayed.

  3. Click Restore Defaults. For more information on default shortcut keys, refer to Data Studio Right-Click Menus.
  4. Click Ok.

    The Restart Data Studio window is displayed.

  5. Click Yes to restart Data Studio. If any export, import or execution operations are in progress, the Process is running dialog box displays.
  6. Click OK to wait for operations to complete or click Force Restart to discard operations.

Shortcut Keys

Data Studio supports keyboard short cut keys similar to other windows based application. The following table lists some of the shortcut keys for effective usage of the functionalities provided by Data Studio. For details about how to customize shortcut keys, see Setting the Shortcut Keys.
Table 1 Default shortcut keys of Data Studio

Function

Shortcut Key

Sorts the result sets of visual charts, edit tables, and queries in ascending, descending, or server receiving order

Alt+Click

Open the Help menu

Alt+H

Save the SQL script

Ctrl+S

Edit menu

Alt+E

Compile/Execute SQL terminal statements

Ctrl+Enter

Search and Replace

Ctrl+F

Search for the previous one

Shift+F3

Search for the next one

F3

Redoing

Ctrl+Y

On the Edit Table Data tab page, copy Execution Time and Status

Ctrl+Shift+K

Copy the database object from the automatic recommendation list

Alt+U

Open the Call Stack, the Breakpoints pane, and the Variables pane

Alt+V

Open the SQL script

Ctrl+O

Step Skip

F8

Step into

F7

Single step exit

Shift+F7

Comment out or cancel the comment line

Ctrl+/

Locate the first element in the Object Browser

Alt+Page Up or Alt+Home

Locate the last element in the Object Browser

Alt+Page Down or Alt+End

Locate to row

Ctrl+G

Disconnect the connection

Ctrl+Shift+D

Formatting (SQL and PL/SQL)

Ctrl+Shift+F

Change the value to uppercase

Ctrl+Shift+U

Change the value to lowercase

Ctrl+Shift+L

Updates the cells or columns in the Edit Table Data, Properties, and Results windows. Click the cell or column header to enable this option

F2

Close the PL/SQL Viewer tab page, Table Data View tab page, Execute Query tab page, or Properties tab page

Shift+F4

Continue the PL/SQL debugging

F9

Shearing

Ctrl+X

Copy Object Browser or the name of the object modified in the terminal. Copy the selected data from the Terminal, Result, Table Data, or Edit Table Data tab page.

Ctrl+C

Copy the data on the Result, Table Data, or Edit Table Data tab page. The data contains/does not contain the column title and row number

Ctrl+Shift+C

Copy the query result on the Edit Table Data tab page

Ctrl+Alt+C

Copy the content on the Variable tab page

Alt+K

Copy the content on the Call Stack tab page

Alt+J

Copy the content on the Breakpoint tab page

Alt+Y

Visualized interpretation plan

Alt+Ctrl+X

Online help (displaying the user manual)

F1

Template

Alt+Ctrl+Space

Switch to the first SQL Terminal tab page

Alt+S

Select All

Ctrl+A

Setting menu

Alt+G

Refresh (in the Object Browser area)

F5

Search Object

Ctrl+Shift+S

Debugging menu

Alt+D

Debugging template

F10

Debugging the Database Object

Ctrl+D

Highlight Object Browser

Alt+X

File menu

Alt+F

Creating a connection

Ctrl+N

Running menu

Alt+R

Switch between the SQL Terminal tab page

Ctrl+Page Up or Ctrl+Page Down

Expand/Collapse All Objects

Ctrl+M

Pastes

Ctrl+V

Collapsible object browsing navigation tree

Alt+Q

Execute

Ctrl+E

Execution plan and expense

Ctrl+Shift+X

Stop the query in the running state

Shift+Esc

Comment/Cancel the comment line or the entire segment

Ctrl+Shift+/

List of automatically recommended database objects

Ctrl+Space