Exporting SQL Execution Results

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.

  1. 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.
  2. Place the cursor on the Result tab or anywhere inside the result set.
  3. Export a single result or all results.
    To export Do this
    A single result Right-click and select Export > Current Result from the context menu.
    All results Right-click and select Export > All Results from the context menu.

    The Export Result or Export All Results dialog appears.

  4. Enter a file name in the File name field, or click the Browse button to browse for the file.
  5. Select a file format from the Format list: Plain Text, XML, HTML, or CSV.
  6. In the Export options field, select the desired output encoding and format from the corresponding drop-down lists.
  7. Click Finish.

    You return to SQL Editor.

Related concepts
SQL Results View
Related tasks
Viewing SQL Results
Saving Execution Results to a Project
Removing Results from SQL Results View
Terminating Results from SQL Results View
Related reference
SQL Results View Tabs