RubyMine 5.4.3 Web Help

To access the Table Editor from the Database tool window:
Select the necessary table in a DB data source, and then press F4F4F4F4F4F4F4F12 or Ctrl+Shift+EF4F4F4F3F4 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+UpAlt+Shift+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpAlt+UpCtrl+Alt+UpCtrl+Shift+UpMeta Alt UpMeta Alt UpMeta Alt UpMeta Alt UpOpen the previous page of the database in the table editor.
dataSourceTableEditorNextPage.pngNext PageCtrl+Alt+DownAlt+Shift+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownAlt+DownCtrl+Alt+DownCtrl+Shift+DownMeta Alt DownMeta Alt DownMeta Alt DownMeta 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+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RMeta+RMeta RMeta RMeta RMeta 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+InsertAlt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+Insert or Ctrl+NAlt+InsertMeta+Shift+N, Ctrl+N or Ctrl+EnterControl N or Control EnterControl N or Control EnterMeta N or Control EnterControl N or Control EnterAdd a new record to the table.
delete.png Delete Selected Rows Ctrl+YCtrl+YCtrl+YCtrl+YCtrl+YCtrl+Shift+LCtrl+ECtrl+DMeta+YMeta YMeta YMeta DMeta Y Remove the selected range of rows from the table.
filter.png Filters and Ordering Ctrl+F12Ctrl+F12Ctrl+0Ctrl+F12Ctrl+F12Ctrl+F12Ctrl+F12 or Ctrl+Shift+F12Ctrl+F3 or Ctrl+OMeta+F12Meta F12Meta F12Meta OMeta 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+CCtrl+Alt+Shift+CCtrl+Alt+Shift+CCtrl+Alt+Shift+CCtrl+Alt+Shift+CCtrl+Alt+Shift+CCtrl+Alt+Shift+CMeta+Alt+Shift+CMeta Alt Shift CMeta Alt Shift CMeta Alt Shift CMeta Alt Shift C Copy to the clipboard the query that has generated the current table view.
icon_sqlCopyValues.png Copy Ctrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+Insert, Alt+C or Escape, WCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertCtrl+C or Ctrl+InsertMeta+C or Meta+InsertMeta C or Meta InsertMeta C or Meta InsertMeta C or Meta InsertMeta C or Meta 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: