After you perform an action on a database, you can view
the results in the SQL Results view. You can save the results to a
file, or you can print the results. This method is useful if you want
to save results information to a data project, where it can be shared
with other team members and compared more easily to other results.
You can also quickly view the results information from within the
workbench.
Before you begin
- Create a data project in the Data Project Explorer
- Run a routine or an SQL query
Procedure
To save and print results from the SQL Results view:
- Ensure that the details pane is in text mode by using the
SQL Results view toolbar icon.
- To save results, right-click the Results tab,
and select or . If you
do not see the Results tab, your database action
did not return any results.
- Select the project folder in which to save the result set,
enter a file name and file type, and specify export options.
- Click OK. The result
set opens in the editor or external tool for the format that you chose.
- To print results, right-click the Results tab,
and select or . If you
do not see the Results tab, your database action
did not return any results.
- Specify print options and click OK. The results are printed.
Note: You might see truncation
on the page when you print results from the SQL Results view.