The Data editor appears:

    • As the Data tab of the Database Object Editor available only for tables and views.
    • As the Results tab when you run a custom SQL query in SQL Editor
      The Data editor allows viewing and editing the data of a database table or view.The central part of the Data editor is the data table. The editor also provides two toolbars and a filter field:

    Data Editor - 图1

    To learn how many rows the data table 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: Data Editor - 图2

    To learn about ways to navigate data in the data table, see Navigation article.

    The top toolbar contains the following buttons:

    ButtonNameDescription
    Data Editor - 图3Apply filter criteriaApplies filter criteria entered in the filter field above the data table, see Data Filters article for more information
    Data Editor - 图4Remove all filters/orderingsRemoves all filters and orderings applied to the data
    Data Editor - 图5Save filter settings for current objectSaves the current filter settings for the database object to apply next time when you reopen it in the editor, see details in Data Filters article
    Data Editor - 图6Custom FiltersOpens the Result Set Order/Filter Settings window, see Data Appearance article for more information
    Data Editor - 图7Configure auto-refreshAllows configuring data auto-refresh settings, see Data Refresh article for details
    Data Editor - 图8Forward and backward - history navigation buttonsNavigate forward and backward in the Data Editor history, see History section of Navigation article for more information. The buttons are equivalent to pressing the key combinations: Alt+Left (backward) and Alt+right (forward).

    The side bar contains the following tabs:

    ButtonNameDescription Chartbutton
    Data Editor - 图9GridSwitches to grid view of data
    Data Editor - 图10TextSwitches to plain text view of data
    Data Editor - 图11ChartSwitches to chart view. For more details on charts, see Managing Charts article.
    Data Editor - 图12Record- Same as pressing Tab- Switches the positions of rows and columns so that columns appear as rows, and rows hide in one Value column, see details in the _Table vs. Record Views section of Data Appearance article.

    The bottom toolbar provides the following buttons:

    ButtonNameDescription
    Data Editor - 图13SaveSaves all unsaved changes to the data such as adding, duplicating, deleting rows, inline editing of values, see Data Viewing and Editing article for information
    Data Editor - 图14CancelDiscards all unsaved changes to the data
    Data Editor - 图15ScriptOpens the Preview Changes window in which you can see changes that you have made to the data, see details in Data Viewing and Editing article
    Data Editor - 图16Edit cell value in separate dialog/editorOpens the cell in focus for editing in a separate editor or dialog box, see details in Cell Editor section of Data Viewing and Editing article
    Data Editor - 图17Add new rowAdds a new empty row below the current row, see details in Adding, Copying and Deleting Rows section of Data Viewing and Editing article
    Data Editor - 图18Duplicate current rowCopies the current rows and pastes the copy below the current row, see details in Adding, Copying and Deleting Rows section of Data Viewing and Editing article
    Data Editor - 图19Delete current rowColors the rows in focus in red to mark them for deletion, see details in Adding, Copying and Deleting Rows section of Data Viewing and Editing article
    Data Editor - 图20Move to first rowMoves the focus (highlighting) from the current to the first row of the table
    Data Editor - 图21Move to previous rowMoves the focus (highlighting) from the current to the previous row of the table
    Data Editor - 图22Move to next rowMoves the focus (highlighting) from the current to the next row of the table
    Data Editor - 图23Move to last rowMoves the focus (highlighting) from the current to the last row of the table
    Data Editor - 图24Fetch next page of resultsFetches the next portion of data (next N rows) making it ready for display, see Scrolling Results Page section of Navigation article for more information
    Data Editor - 图25Fetch all rowsFetches the whole result set making it ready for display, see Scrolling Results Page section of Navigation article for more information
    Data Editor - 图26PanelsOpens panels on the right side of the Data Editor, see Panels for information
    Data Editor - 图27ConfigureOpens a dropdown menu with settings
    Data Editor - 图28JSON- Available in EE version only for MongoDB documents and JSON tables- Switches to JSON view of data
    Data Editor - 图29XML- Available in EE version only for XML tables- Switches to XML view of data
    Data Editor - 图30Generate Mock DataOpens the Mock Data Generator window, see TBD for details
    Data Editor - 图31Rows count detailsOpens the Status details dialog box showing the timing details of fetching table rows
    Data Editor - 图32Calculate total row countCalculates the total number of rows in the table

    Every cell in the data table has a context menu – right-click the cell to open the menu. The context menu provides the following items:

    Menu ItemDescription
    CutCuts the content of the current cell or column to the clipboard
    CopyCopies the content of the current cell or column to the clipboard
    Advanced CopyOpens advanced copy submenu that allows copying data with preset formatting parameters
    PastePastes the copied content to the cells in focus
    Advanced PastePastes several values delimited with a tabulation or line break
    DeleteDeletes the row that has the cell in focus NOTE: In fact, when users click Delete, the system only highlights the row red while the actual deletion happens when users click Save.
    Edit cell-For CLOB/BLOB data format, opens the contents of the cell in a new tab - For all formats except CLOB/BLOB, opens a properties window for the cell
    Inline edit- Same as double-click on a cell- Makes the cell editable
    Set to NULLSets the value of selected cells to NULL
    Hide columnHides the column currently in focus, see the Managing Display of Columns in Data Table section further in this article
    Save to file…- Appears only for columns with BLOB/CLOB data- Opens the standard Save As window that allows saving data contained in the cell to a file
    Load from file…- Appears only for columns with BLOB/CLOB data- Opens a standard window for opening files
    Order/FilterDisplays a submenu that allows selecting 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.
    View/FormatOpens a submenu that provides tools for formatting and modifying the view of data, see Data View and Format
    NavigateOpens a submenu that helps users navigate throughout the data table, see Navigation
    LayoutChanges the layout of data, see the Table vs. Record Views section of the Data View and Format article
    Export ResultsetOpens the Data Transfer wizard that guides you through the steps to select a format and export dataNOTE: The system exports the whole result set including records that are not visible in the screen and preserves all applied data filters and ordering.
    Generate SQLOpens a submenu on which you can select the type of SQL query to generate
    RefreshRefreshes the whole results set including all items that are not visible in 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.