From the Database tool window (for any table within a DB data source):
Use the Table Editor to manipulate the table data, and to perform other, associated tasks.
There are two tabs in the Table Editor:
- Data. On this tab, the table you are working with is shown.
CREATE TABLEstatement used to create the table is shown on this tab. You can edit the statement and then run it ( on the toolbar or Ctrl+Shift+F10). Use or Ctrl+F5 to regenerate the
CREATE TABLEstatement for the current state of the table in the database.
- Toolbar controls, context menu commands for data cells and keyboard shortcuts
- Using the table header row: sorting data, reordering and hiding columns
See also, Working with the Table Editor.
Toolbar controls, context menu commands for data cells and keyboard shortcuts
|, , and||
These icons and corresponding commands are for switching between the result set pages,
i.e. the pages that show the
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 Settings dialog.
|First Page||Use this icon or command to switch to the first of the result set pages to see the first series of rows.|
|Previous Page||Ctrl+Alt+Up||Use this icon, command or shortcut to switch to the previous result set page to see the previous series of rows.|
|Next Page||Ctrl+Alt+Down||Use this icon, command or shortcut to switch to the next result set page to see the next series of rows.|
|Last Page||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||Alt+Insert||
Use this icon, command or shortcut to add a new row to the table.
See also, Adding a row.
|Delete Rows||Ctrl+Y||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.
Use this check box
to turn the autocommit mode for the database connection on or off.
In the autocommit mode, each SQL statement is executed in its own transaction that is implicitly committed. Consequently, the SQL statements executed in this mode cannot be rolled back.
(Each change of a value in the table, or adding or deleting a row - when submitted to the database server - results in executing an SQL statement.)
If the autocommit mode is off, transactions are committed or rolled back explicitly by means of the commit or rollback command. Each commit or rollback starts a new transaction which provides grouping for a series of subsequent SQL statements.
In this case, the data manipulations in the transaction scope are committed or rolled back all at once when the transaction is committed or rolled back.
|Commit||If the autocommit mode is off, use this icon or command to commit the current transaction.|
|Rollback||If the autocommit mode is off, use this icon or command to roll back the current transaction.|
|Cancel Query||Ctrl+F2||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 table editor 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.|
|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, press Escape.|
This icon provides access to the following commands:
Specify filtering conditions for the table.
(If the filter box is not currently shown, click on the toolbar and
select Row Filter.)
The filtering conditions are specified as in a
To apply the conditions currently specified in the box, press Enter. To cancel filtering, click , or delete the contents of the filter box and press Enter.
To reapply a memorized filter, click and select the filter in the list. See also, Filter history size.
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 Ctrl+Space. To enter the modified value, press Enter. To cancel editing, press Escape.
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, press Escape.
See also, Modifying cell contents.
|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 |
|Load File||If appropriate: Load a file into the field.|
|Submit||Ctrl+Enter||Submit the changes to the database server. See Submitting and reverting changes.|
|Revert||Ctrl+Z||Revert the changes within the selection. See Submitting and reverting changes.|
|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, press Escape. For more information, see Using the quick documentation view.|
|Transpose||Turn the transposed table view on or off. Alternatively, use .|
|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.|
|Go To | Related Data||F4||
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||Ctrl+B||
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:
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, Copying and pasting data: data types are converted if necessary.|
|Paste||Ctrl+V||Paste the contents of the clipboard into the table. See also, Copying and pasting data: data types are converted if necessary.|
|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 Selecting cells and ranges: using unobvious techniques.|
Using the table header row: sorting data, reordering and hiding columns
Use the cells in the header row (i.e. the row where column names are shown) for:
You can sort table data by any of the columns by clicking the cells in the header row.
Each cell in this row has a sorting marker in the right-hand part and, initially, a cell may look something like this: . The sorting marker in this case indicates that the data is not sorted by this column.
If you click the cell once, the data is sorted by the corresponding column in the ascending order. This is indicated by the sorting marker appearance: . 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.)
When you click the cell for the second time, the data is sorted in the descending order. Here is how the sorting marker indicates this order: .
Finally, when you click the cell for the third time, the initial state is resorted. That is, sorting by the corresponding column is canceled: .
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 show a hidden column:
Do one of the following:
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 Enter or Escape to close the list.