Viewing Data in Grid Overview

Data Editor allows you to view and quickly edit data right in the grid.

To retrieve data, do any of the following:

  • Click Results as Grid on the SQL toolbar before executing a query that returns data.
  • Open a table or view editor and switch to the data view.

Note

If you want to retrieve all data from a table with a large number of records, a message warning you about the possibility of the “Out of memory” exception is shown, and you can choose either of the following actions - continue retrieving data, cancel retrieving data, or turn on Paginal Mode. By default, Paginal Mode is enabled in data view with 1000 records per page, so only 1000 records are displayed at once.

To simplify data analysis, you can use the following features:

  • Grouping Data in Grid
  • Sorting Data in Grid
  • Filtering Data in Grid
  • Paginal Mode
  • Card View
  • Auto-search Mode
  • Data Viewer and Editor