From the Database tool window (for any table within a DB data source):
on the toolbar (if the toolbar is not currently hidden)
Open Editor from the context menu
The data editor provides a GUI for working with table data. It lets you sort, filter, add, edit and remove the data as well as perform other, associated tasks.
Toolbar controls, context menu commands for data cells and keyboard shortcuts
Most of the available functions are accessed by means of controls on the toolbar, context menu commands for the data cells, and associated keyboard shortcuts.
, , and
| These icons and corresponding commands are for switching between the result set pages, i.e. the pages that show the table data. |
A fixed number of rows shown simultaneously is referred to as a result set page. If this number is less than the number of rows in the table, only a subset of all the rows is shown at a time.
In such cases, you can use , , and to switch between the subsets. (If all the rows are currently shown, these icons and the corresponding commands are inactive.)
The result set page size is set on the Database page of the Preferences dialog.
Use this icon or command to switch to the first of the result set pages to see the first series of rows.
Use this icon, command or shortcut to switch to the previous result set page to see the previous series of rows.
Use this icon, command or shortcut to switch to the next result set page to see the next series of rows.
Use this icon or command to switch to the last of the result set pages to see the last series of rows.
| Use this icon, command or shortcut to refresh the current table view. Use this function to: |
Add New Row
| Use this icon, command or shortcut to add a new row to the table. |
Complete entering a value into a cell by pressing⏎. To save the new row, select Submit New Row from the context menu or press ⌘⏎.
|Use this icon, command or shortcut to delete the selected row or rows. |
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.
Tx and Tx Isolation
| Select the isolation level for database transactions and the way the transactions are committed. |
Submit local changes to the database server. See Submit changes manually.
Commit the current transaction. See also, Tx.
Roll back the current transaction. See also, Tx.
Use this icon or shortcut to terminate execution of the current query.
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:
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.
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, press⎋.
| This icon provides access to the following commands: |
| 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, press⌃Space. To enter the modified value, press⏎. To cancel editing, press⎋.
| Maximize the selected cell and start editing a value in it. |
When working in a maximized cell, use ⏎ to start a new line and ⌘⏎ to enter the value. To restore an initial value and quit the editing mode, press⎋.
If appropriate: Set the default value or values.
If appropriate: Replace the value or values with
If appropriate: Load a file into the field.
Use this command or shortcut to create a copy of the selected row.
Turn the transposed table view on or off. Alternatively, use.
Go To | Row
Use this command or shortcut to switch to a specified row. In the dialog that opens, specify the row number to go to.
Go To | Related Data
| Use this command or shortcut to switch to a related record. The command options are a combination of those for Go To | Referenced Data and Go To | Referencing Data. |
The command is not available if there are no related records.
Go To | Referenced Data
| 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
| 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: |
The command is not available if there are no records that reference the current one.
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.
Use this command to save the large object (LOB) currently selected in the table in a file.
⌃G, ⌃⇧G, ⌥↑
To sort table data in a column, click the cell in the header row.
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.
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.
In the list that appears, the names of hidden columns are shown struck through.
Select (highlight) the column name of interest and press Space.
Press ⏎ or ⎋ to close the list.
To show all the columns, click and select Reset View.