The settings on this page define how table data is shown and modified in your query consoles, data editors, and so on.
Limitations
Option
Description
Limit page size to
Number of table rows that are shown on one page. If you do not want to limit the number of rows displayed simultaneously, clear the checkbox.
Also, you can change the page size by clicking the Change page size list of the pagination toolbar.
Consider the following example where Limit page size to is set to 2:
Result set prefetch size
Number of rows from a database that is retrieved in one chunk.
A bigger number means less round trips between IDE and a database but more memory for storing a chunk.
Filter history size
Number of recently-used filtering conditions that are saved for a table in a data editor. Consider the following example where Filter history size is set to 2. The filter history box contains only two conditions.
To open the filter history in the editor, click the WHERE or ORDER BY field and press Alt+Down.
Maximum number of bytes loaded per value
Maximum size of a binary large object to be loaded in bytes.
Show first N data rows in preview
Limit number of rows for a quick documentation popup. To see quick documentation, press Ctrl+Q.
Data Presentation
Option
Description
Automatically transpose tables
Configure when you want to transpose tables and views when you open them in the data editor. In a transposed view, columns and rows are interchanged. Note that this setting does not transpose query results.
Never: do not transpose a table.
If a table has one record: transpose only tables with a single record.
Always: always transpose tables.
Automatically detect binary values
Enables the default display type for binary values.
Enable local filter by default
Enables the locally run data filter that runs locally for each newly opened grid.
For more information about data sorting, refer to the Sort data topic.
Option
Description
Sort via ORDER BY
Enables the default sorting method as sorting by sending the ORDER BY query each time you reopen the table.
Sort tables by numeric primary key
Configures how to sort table records by the numeric primary key. Two options are available: Ascending or Descending.
Add columns to sorting
Select what action to use when you want to add columns to stacked sorting. The default is Alt and a click.
When you click the column name, the column data is sorted. The column sorting is not stacked by default. It means that if you click a column name to sort data by, the sorting based on other columns will be cleared. If you prefer to use the stacked sorting, click a column name while pressing Alt.
Data Modification
Option
Description
Submit changes immediately
Submit changes instantly. For more information about submitting your changes to a database, refer to Submit changes to a database.
