In the Database tool window, do one of the following:
- Click the table of interest and click on the toolbar (if the toolbar is not currently hidden).
- Select the table and press F4F4F4F4F4F4F4F12 or Ctrl+Shift+ECommand Down or F4F4F3.
- Right-click the table and select Table Editor from the context menu.
As a result, the table opens in the Table Editor on a separate editor tab.
If only a subset of all the rows is currently shown, to switch between the subsets, use:
- First Page
- Previous Page (Ctrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpCtrl+Alt+UpAlt Command UpAlt Command UpAlt Command Up)
- Next Page (Ctrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownCtrl+Alt+DownAlt Command DownAlt Command DownAlt Command Down)
- Last Page
If you want all the rows to be shown simultaneously:
- Click on the toolbar of the Table Editor.
- In the Database dialog that opens, specify 0 in the Result set page size field, and click OK.
- Click or press Ctrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RConsole.TableResult.ReloadCommand RConsole.TableResult.Reload to refresh the table view.
To switch to a row with a specified number:
Do one of the following:
- Press Ctrl+GCtrl+GCtrl+GCtrl+GAlt+GCtrl+GCtrl+GCtrl+LCommand LCommand GCommand L.
- Right-click the table, and select from the context menu.
- Select from the main menu.
- In the dialog that opens, specify the row number and click OK.
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: .
- If the filter box is not currently shown, click on the toolbar.
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.
- EnterEnterEnterEnterEnterEnterEnterEnterEnterEnterEnter to apply the conditions currently specified in the box.
to open the list of all the conditions that you have used.
Select the condition in the list to apply it again.
- 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.
- EscapeEscapeEscapeEscapeEscape, Escape or Ctrl+GEscapeEscapeEscapeEscapeEscapeEscape to restore the initial (unfiltered) table view and hide the box.
To reorder columns, use drag-and-drop for the corresponding cells in the header row.
- To start editing a field, double-click the corresponding table cell.
Edit the cell contents. To do that, you have the following options:
- Modify the data right in the cell. To save the changes, press EnterEnterEnterEnterEnterEnterEnterEnterEnterEnterEnter.
Click or press Shift+EnterShift+EnterShift+EnterShift+EnterShift+EnterShift+EnterShift+EnterShift+EnterShift EnterShift EnterShift Enter
to open the Enter text data or choose file dialog.
In this dialog you can:
- Make the necessary edits in the upper area.
- Upload a file into the field. To do that, click Browse and select the desired file in the Choose Path dialog.
- Insert null into the field (click Null).
- To leave the editing mode, click a different cell or press EscapeEscapeEscapeEscapeEscape, Escape or Ctrl+GEscapeEscapeEscapeEscapeEscapeEscape.
- Do one of the following:
- Press Alt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+Insert or Ctrl+NAlt+InsertCommand N or Control EnterControl N or Control EnterCommand N or Control Enter.
- Click Add New Row on the toolbar of the Table Editor.
- Select Add New Row from the context menu.
- Fill in the fields. Use the EnterEnterEnterEnterEnterEnterEnterEnterEnterEnterEnter or the TabTabTabTabTabTabTabTabTabTabTab key to indicate the end of your input in the current cell and move on to the next cell. The new record is saved when you press EnterEnterEnterEnterEnterEnterEnterEnterEnterEnterEnter or TabTabTabTabTabTabTabTabTabTabTab in the last of the cells.
- Select the row or rows that you want to delete. To do that:
- If you are going to delete one row, select any of the cells within the corresponding row.
- If you are going to delete a range of rows, select one or more cells in each of the corresponding rows.
You can select only the rows that follow one another.
- Do one of the following:
- Press Ctrl+YCtrl+YCtrl+YCtrl+YCtrl+YCtrl+Shift+LCtrl+ECtrl+DCommand BackspaceCommand YCommand D.
- Click Delete Selected Rows on the toolbar of the Table Editor.
- Select Delete Selected Rows from the context menu.
- Confirm your intention to delete the selected row or rows by clicking OK in the corresponding dialog.
You can save large objects (LOBs) stored in database tables in local files. To do that:
- Select the cell containing the large object of interest.
- Do one of the following:
- Click Save LOB As on the toolbar of the Table Editor.
- Select Save LOB As from the context menu.
- In the Select File to Save dialog:
- Specify the destination directory in the upper part.
- Type the name of the file File name field.
- Click OK.
You may want to refresh the view of a table in the Table Editor in order to:
- Synchronize the data shown with the actual contents of the table in the database.
- Apply the changed page size setting to the current table view.
In all such cases, use the Reload Page command:
- Press Ctrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RCtrl+RConsole.TableResult.ReloadCommand RConsole.TableResult.Reload.
- Click Reload Page on the toolbar of the Table Editor.
- Select Reload Page from the context menu.