IntelliJ IDEA 12.1.0 Web Help

Some features described here are available in Ultimate edition only.

To access the Table Editor from the Database tool window:
Select the necessary table in a DB data source, and then press F4F4 or select Table Editor from the context menu.

Use the toolbar buttons, context menu commands, and keyboard shortcuts available in the Table Editor to manipulate table data and perform associated tasks.

Toolbar buttons, context menu commands and keyboard shortcuts

ButtonCommandShortcutFunction
dataSourceTableEditorFirstPage.pngFirst PageOpen the first page of the database in the table editor.

Note

Table rows are distributed among pages which are shown one at a time. Each page accommodates the same number of rows. The number of rows per page is configurable in the General tab of the Table Editor Properties dialog box.

dataSourceTableEditorPreviousPagePrevious PageCtrl+Alt+UpCtrl+Alt+UpOpen the previous page of the database in the table editor.
dataSourceTableEditorNextPage.pngNext PageCtrl+Alt+DownCtrl+Alt+DownOpen the next page of the database in the table editor.
dataSourceTableEditorLastPage.pngLast PageOpen the last page of the database in the table editor.
refresh.pngReload PageCtrl+RCtrl+RRefresh the current table view. Use this function to:
  • Synchronize the currently shown data with the actual contents of the table in the database.
  • Apply the page size setting after its change.
add.pngAdd New RowAlt+InsertCommand N; Command EnterAdd a new record to the table.
delete.png Delete Selected Rows Ctrl+YCtrl+Y Remove the selected range of rows from the table.
filter.png Filters and Ordering Ctrl+F12Ctrl+F12 Open the Filters and Ordering dialog to specify sorting and filtering conditions.
properties.gif PropertiesOpen the Table Editor Properties dialog to set the number of rows per page or to specify data export format.
icon_sqlCopyQuery.png Copy Query Ctrl+Alt+Shift+CCtrl+Alt+Shift+C Copy to the clipboard the query that has generated the current table view.
icon_sqlCopyValues.png Copy Ctrl+C; Ctrl+InsertCtrl+C; Ctrl+Insert Copy the values currently selected in the table to the clipboard. The format of data placed to the clipboard is defined by the data export format.
mainToolbarSave.gif Save LOB AsSave the large object (LOB) currently selected in the table in a file.

See Also

Language and Framework-Specific Guidelines:

Reference:

Web Resources: