You can export a single result set or all execution results.
Exporting saves the result set to a file outside of any project for use with other applications.
-
In
the SQL Results view, if you are in single-window mode, change to mult-window mode by clicking
Multiple windows
in the
SQL Results View Options page of the Preferences dialog.
-
Place the cursor on the
Result tab or anywhere inside the
result set.
-
Export a single result or all results.
To export |
Do this |
A single result |
Right-click and select
from the context menu. |
All results |
Right-click and select
from the context menu. |
The
Export Result
or Export All Results dialog appears.
- Enter a file name in the File name field, or click the Browse button to browse for the file.
-
Select a file format from the
Format
list: Plain Text, XML, HTML, or CSV.
- In the Export options field, select the desired output encoding and format from the corresponding drop-down lists.
-
Click Finish.
You return to SQL Editor.