Table of contents
The Data editor appears:
- as the Data tab of the Database Object Editor, which is only available for tables and views;
- as the Results tab when you run a custom SQL query in SQL Editor.
The Data editor allows to view and edit data of a database table or view. The central part of the Data editor is the data grid. The editor also provides top toolbar, bottom toolbar, left side bar, right side bar and a filter field:
To learn how many rows the table data contains, click the Calculate total row count button in the bottom toolbar. The number of rows appears in a status field next to the button:
To learn about ways to navigate data in the table data, see Navigation article.
The top toolbar contains the following buttons:
|Remove all filters/orderings
|Removes all filters and orderings applied to the data in the filter field.
|Save filter settings for current object
|Saves the current filter settings for the database object to apply next time when you reopen it in the editor, see details in the Data Filters article.
|Opens the Result Set Order/Filter Settings window. See Data Filters article for more information.
|Forward and backward - history navigation buttons
|Navigate forward and backward in the Data Editor history, see the history section of our article for more information.
Left side bar
The left side bar contains the following tabs:
|Switches to the grid view of data.
|Switches to the plain text view of data.
|Switches to the spatial view. For more details, see the GIS data article.
|Switches to the chart view. For more details on charts, see the Managing Charts article.
|- Same as pressing Tab
- Switches the positions of rows and columns so that the columns appear as rows, and the rows hide in one Value column. See details in the Table vs. Record Views section of our article.
Right side bar
The right side bar contains the following tabs (see the Panels for more information):
|Opens panels on the right side of the Data Editor.
|Opens the result cells calculation panel (SUM, MAX, AVG, etc.).
|Opens grouping panel window tools.
|Opens Metadata panel.
|Opens References panel.
|Opens Value Viewer.
The bottom toolbar provides the following buttons:
|Refreshes the whole results set, including all items that are not visible on the screen, while its dropdown option allows to customize the refresh frequency over a specific period.
|Saves all unsaved changes to the data such as adding, duplicating, deleting rows, inline editing of values. See the Data Viewing and Editing article for information.
|Discards all unsaved changes to the data.
|Edit cell value in separate dialog/editor
|Opens the cell in focus for editing in a separate editor or dialog box. See details in the Cell Editor section of our article.
|Add new row
|Adds a new empty row below the current row, see details in the Adding, Copying and Deleting Rows section of our article.
|Duplicate current row
|Copies the current rows and pastes the copy below the current row, see details in Adding, Copying and Deleting Rows section of our article.
|Delete current row
|Colors the rows in focus in red to mark them for deletion, see details in the Adding, Copying and Deleting Rows section of our article.
|Move to first row
|Moves the focus (highlighting) from the current to the first row of the table.
|Move to previous row
|Moves the focus (highlighting) from the current to the previous row of the table.
|Move to next row
|Moves the focus (highlighting) from the current to the next row of the table.
|Move to last row
|Moves the focus (highlighting) from the current to the last row of the table.
|Fetch all data
|Fetches the whole result set making it ready for display. See the Scrolling Results Page section of our article.
|Opens a menu with settings.
|Result-set fetch size
|Displays the initial fetch number of rows in the result set on loading or refreshing.
|Calculate total row count
|Calculates the total number of rows in the table.
Note: Some of these buttons may be disabled and may not work if you are using a read-only connection, connecting to a read-only database or if you see the result of a complex query, such as joining two or more tables.
Column context menu
Each column has a context menu, accessed by clicking the downward arrow button , providing different filter options.
Cell context menu
Every cell in the table data also has a context menu – right-click the cell to open the menu. The context menu provides the following items:
|Copies the content of the current cell or column to the clipboard.
|Opens advanced copy submenu that allows copying data with preset formatting parameters.
|Pastes the copied content to the cells in focus.
|Pastes several values delimited with a tabulation or line break starting from the selected cell.
|Deletes the row that has the cell in focus.
NOTE: In fact, when users click Delete, the system only highlights the red row while the actual deletion happens when users click Save.
|Opens a submenu enabling inline editing. See the Data Viewing and Editing article.
|Displays a submenu that allows to specify ordering criteria for the data. The submenu contains the most common ordering options that can be applied to the column in focus. See details in Data Filters article. By default, DBeaver orders data by sending a request to the server (the Server-side results ordering checkbox selected). To order data on the client side using DBeaver's internal algorithm, clear the checkbox.
|Displays a submenu that allows to specify filter criteria for the data. The submenu contains the most common filters that can be applied to the cell in focus. See details in Data Filters article. By default, DBeaver filters data by sending a request to the server (the Server-side results ordering checkbox selected). To filter data on the client side using DBeaver's internal algorithm, clear the checkbox.
|Opens a submenu that provides options for formatting and modifying the view of data. See the Data View and Format article.
|Opens a submenu that helps users to navigate through the table data. See the Navigation article.
|Changes the layout of data, see the Data View and Format article.
|Opens the Data Transfer wizard that guides you through the steps to export data to a selected format. See the Data Transfer article.
Note: The system exports the whole result set including records that are not visible on the screen and preserves all applied data filters and ordering.
|Opens a submenu where you can select the type of SQL query to generate. See the SQL Generation article.
|Generate Mock Data
|Opens Mock Data Generator. See the Mock Data Generation in DBeaver article.
|Opens a submenu allowing you to write virtual column expressions. See the article about Virtual column expressions.
|Opens the data in external applications like Excel or a web browser.
|Toggle result panel
|Opens Value Viewer panel on the right side of the Data Editor.
|Refreshes the whole results set including all items that are not visible on the screen.
For more information about using the Data Editor, please see the subsections of this article - open them via the contents tree on the right.