# SQL Results View Options Preferences

The SQL Results view preferences determine the behavior of the SQL Results view.

Table 1. SQL Results view options
Field | Explanation
--- | ---

Display Window

Select a window display style:

- Single Window — display execution results in a single window, with status details at the end. For a single statement with multiple results, display result sets one after another in the same window.
- Multiple Windows — display execution status and each result for the current statement in a separate window.

Display Mode

Select a results display mode:

- Text Mode — similar to iSQL output when in single-tab mode.
- Grid Mode — similar to the Interactive SQL window.

Show Column Headings | Show column headings in the results view.

Show Row Number

Show row numbers in results view.

- In text mode, this property is always enabled.
- In grid mode, this property is selected by default.

Show Row Count Message

Show number of rows affected.

- In text mode, this property is always enabled. Row count appears at the end of the results.
- In grid mode, this property is selected by default. Row count appears in the Status window.

Max Row Count | Enter the number of rows to retrieve from the result set. The default is 0 (retrieve all rows). Set a maximum to improve performance when testing queries and to avoid running out of memory when retrieving data from very large tables, for example, tables with a hundred million rows.
Max Display Row Count | Enter number of rows to display in the results view. To see all results, set Maximum Rows to Retrieve to 0, and then save to a file.
Display Null Value As | Enter characters to display when the value is NULL. Default is NULL.
Split All Messages Into Multiple Message Tabs | Split messages among more than one tab.
Limit Tabs Number to | If you selected Multiple windows for the Display Window preference, enter a maximum number of tabs.
Limit Visible Tables Number to | If you selected Single window for the Display Window preference, enter a maximum number of visible tables.

Related concepts
SQL Results View
Related tasks
Setting SQL Development Preferences
Viewing SQL Results
Related reference
Execution Plan View Options Preferences
General Preferences
SQL Editor Preferences
SQL Query Builder Preferences
Export Format Options Preferences
History Options Preferences
Result Set Viewer Preferences