Use this icon or shortcut to terminate execution of the current query.

Compare With

Use this icon to compare the current table with another table. The tables open in the data editors and ones shown in the Database Console tool window are suggested for comparison.

Data Extractor: <current_format>

Use this button or command to open a menu in which you can select an output format for your data.

In addition to output formats, there are also the following options and commands:

Allow Transposition. For delimiter-separated values formats (TSV, CSV): If the table is shown transposed and you are copying selected cells or rows to the clipboard (e.g.Ctrl+C), the selection is copied transposed (as shown) if the option is on and non-transposed (as in the original table) otherwise.

Go to Scripts Directory. Switch to the directory where the scripts that convert table data into various output formats are stored.

Dump Data | To Clipboard

Use this command to copy the table data onto the clipboard.

Dump Data | To File

Use this command to save the table data in a file. In the dialog that opens, specify the location and name of the file.

Export to Database

Export the data to another table, schema or database. Select the target schema (a new table will be created) or table (the data will be added to the selected table). In the dialog that opens, specify the data mapping info and the settings for the target table.

View Query

Use this button to view the query which was used to generate the current table view. To close the pane where the query is shown, pressEscape.

This icon provides access to the following commands:

Transpose. Turn the transposed table view on or off. (In the transposed view, the rows and columns are interchanged. So, the rows are shown as columns and vice versa.)

Reset View. Restore the initial table view after reordering or hiding the columns, or sorting the data.

Sort via ORDER BY. Turn the corresponding option on or off.

If the Sort via ORDER BY option is on, all the sorting operations that you perform are reflected in the corresponding SELECT statement (an ORDER BY clause is added or modified) which is executed immediately. As a result, the data for the whole table is sorted by the corresponding database system.

Don't turn this option on if you want to keep interactions with the database to a minimum (e.g. when the table is very big or the database connection is "slow").

If this option is off, the data is sorted "locally" by RubyMine and only for the rows currently shown.

Row Filter. Show or hide the filter box.

Settings. Open the Database page of the Settings dialog to view or edit the settings for your database consoles, data editors and the Database tool window.

Edit

F2

Use this command or shortcut to start editing a value in the selected cell or cells. (Alternatively, you can double-click the cell or simply start typing.)

To open the value completion suggestion list, pressCtrl+Space. To enter the modified value, pressEnter. To cancel editing, pressEscape.

See also, and .

Edit Maximized

F2

Maximize the selected cell and start editing a value in it.

When working in a maximized cell, use Enter to start a new line and Ctrl+Enter to enter the value. To restore an initial value and quit the editing mode, pressEscape.

See also, .

Set DEFAULT

Ctrl+Alt+D

If appropriate: Set the default value or values.

Set NULL

Ctrl+Alt+N

If appropriate: Replace the value or values with null.

Load File

If appropriate: Load a file into the field.

Revert

Ctrl+Z

Revert the changes within the selection. See .

Clone Row

Ctrl+D

Use this command or shortcut to create a copy of the selected row.

Quick Documentation

Ctrl+Q

Use this command or shortcut to open the quick documentation view. To close the view, pressEscape. For more information, see .

Transpose

Turn the transposed table view on or off. Alternatively, use | Transpose.

Go To | Row

Ctrl+G

Use this command or shortcut to switch to a specified row. In the dialog that opens, specify the row number to go to.

Use this command or shortcut to switch to a record that the current record references. If more than one record is referenced, select the target record in the pop-up that appears.

The command is not available if there are no referenced records.

Go To | Referencing Data

Alt+F7

Use this command or shortcut to see the records that reference the current record. In the pop-up that appears there are two categories for the target records:

First Referencing Row. All the rows in the corresponding table will be shown and the first of the rows that references the current row will be selected.

All Referencing Rows. Only the rows that reference the current row will be shown.

The command is not available if there are no records that reference the current one.

Filter by

Use this command to access quick filtering options. The options include those for the current column name and depend on the value in the current cell.

Copy

Ctrl+C

Copy the selection onto the clipboard. See also, .

Paste

Ctrl+V

Paste the contents of the clipboard into the table. See also, .

Save LOB

Use this command to save the large object (LOB) currently selected in the table in a file.

Alt+J, Shift+Alt+J, Ctrl+W

See .

Sorting data

To sort table data in a column, click the cell in the header row.

State

Description

Indicates that the data is not sorted in this column. The initial state of the sorting marker.

The data is sorted in the ascending order. The number to the right of the marker (1 on the picture) is the sorting level. You can sort by more than one column. In such cases, different columns will have different sorting levels.

The data is sorted in the descending order.

Here is an example of a table where data are sorted by two of its columns.

To restore the initial "unsorted" state for the table, click and select Reset View. See also, Sort via ORDER BY.

Reordering columns

To reorder columns, use drag-and-drop for the corresponding cells in the header row.

Hiding and showing columns

To hide a column, right-click the corresponding header cell and select Hide column.

To show a hidden column:

Do one of the following:

Right-click any of the cells in the header row and select Column List.

PressCtrl+F12.

In the list that appears, the names of hidden columns are shown struck through.