IntelliJ IDEA 14.0.0 Web Help

Working with the Table Editor

The Table Editor provides a graphical interface for working with table data. You can sort, filter, add, edit and remove the data as well as perform other, associated tasks.

Opening a table in the Table Editor

  • In the Database tool window, do one of the following:
    • Click the table of interest and click DataTables on the toolbar (if the toolbar is not currently hidden).
    • Select the table and press F4.
    • Right-click the table and select Table Editor from the context menu.

Protecting a table from accidental modifications

Navigating through subsets of rows

Making all rows visible simultaneously

  1. Click settings on the toolbar of the Table Editor.
  2. On the Database page that opens, specify 0 in the Result set page size field, and click OK.
  3. Click refresh or press Ctrl+R to refresh the table view.

Navigating to a specified row

  1. Do one of the following:
    • Press Ctrl+G.
    • Right-click the table and select Go To | Row from the context menu.
    • Select Navigate | Row from the main menu.
  2. In the dialog that opens, specify the row number and click OK.

Navigating to related records

Sorting data

Filtering data

  1. If the filter box is not currently shown, click IconDBToolbarMenu on the toolbar and select Row Filter.
  2. In the filter box, specify filtering conditions.

    The filtering conditions are specified as in a WHERE clause but without the word WHERE, e. g. name like '%y%' and relation <> 'sister'. Within the like expressions, the SQL wildcards can be used: the percent sign (%) for zero or more characters and underscore (_) for a single character.

    TableEditorFilteredTable

    Use:

    • Enter to apply the conditions currently specified in the box.
    • find1 to open the list of all the conditions that you have used. Select the condition in the list to apply it again.
      TableEditorFilterHistory
    • clear to clear the box and restore the initial table view (i.e. when no filtering is applied). When the box is empty, clicking this button hides the box.
    • Escape to restore the initial (unfiltered) table view and hide the box.

Using quick filtering options

  1. Right-click a cell of interest and point to Filter by.
  2. Select the necessary condition from the list.

Reordering columns

Hiding and showing columns

Restoring the initial table view

Using the Structure view to sort data, and hide and show columns

Using the quick documentation view

Transposing the table

Modifying cell contents

  1. To start editing a value or uploading a file, do one of the following:
    • Double-click the corresponding table cell.
    • Click the cell and start typing.
    • Right-click the cell and select Edit Value from the context menu.
    • Click the cell and press F2.
  2. Now you can edit the value right in the cell, or open a dialog which gives you more room for editing and additional options. Do one of the following:
    • Modify the value right in the cell. To save the changes, press Enter or click a different cell. To restore an initial value and quit the editing mode, press Escape.
    • Click browseButton or press Shift+Enter. In the dialog that opens, you can:
      • Make the necessary edits in the upper area.
      • Upload a file into the field (e.g. to replace an existing file with a new one). To do that, click Load file and select the necessary file in the dialog that opens.
      • Replace the current value with null (click Set NULL).

Adding a row

  1. To start adding a row, do one of the following:
    • Click DBAddRow on the toolbar.
    • Right-click the table and select Add New Row from the context menu.
    • Press Alt+Insert.
  2. To enter values into the cells, use the same procedure as in the case of Modifying cell contents.

Deleting rows

  1. Select the row or rows that you want to delete.

    Rows are selected by clicking the cells in the column where the row numbers are shown. To select more than one row, use mouse clicks in combination with the Ctrl key.

  2. Do one of the following:
    • Click DBDeleteRows on the toolbar.
    • Press Ctrl+Y or Delete.
  3. Confirm you intention to delete the selected row or rows.

Managing database transactions

Copying a table to the clipboard or saving table in a file

  1. Right-click the table and select Copy All To Clipboard or Save All To File from the context menu.
  2. If you are saving the table in a file, specify the file name and location.

Copying a selection to the clipboard

Changing table output format

  1. Do one of the following:
    • Click DataExtractorButton on the toolbar.
    • Right-click the table and point to Data Extractor: <extractor_name> in the context menu.
  2. Do one of the following:
    • To make a different extractor active, click the name of the desired extractor.
    • To create a new extractor, or to view or modify the settings for an existing extractor, click Configure Extractors. As a result, the Data Extractors dialog will open.

Saving a LOB in a file

  1. Right-click the cell that contains the LOB of interest and select Save LOB To File.
  2. In the dialog that opens, specify the name and location of the destination file and click OK.

Updating the table view

Viewing the query

Working with the CREATE TABLE statement

See Also

Language and Framework-Specific Guidelines:

Web Resources:

Last modified: 12 November 2014
comments powered by Disqus