When you execute SQL in the Editor or the Query Builder, a log of executed commands displays in the Messages tab.
The Messages tab is cleared automatically each time you execute a full script. However, if you execute a partial script multiple times, each execution displays in the tab.
If a script contains message or notice statements, the messages/notices display in the Messages tab.
To switch between the grid and a text view of the output, right-click the Messages tab and select Text Output. This is useful when using PRINT statements.
To re-execute a statement, right-click the statement in the Messages tab (non-text output) and select Re-execute.
When you execute an Automation script, the execution log displays in the Log tab of the Automation window. See Execute and Schedule Automation Scripts and Automate Tasks for more information about Automation scripts.
To troubleshoot errors encountered when executing scheduled Automation scripts, see Troubleshooting Scheduled Automation Scripts.
Tip: To switch between the grid and a text view of the log, right-click in the Log tab and select Text Output.
You can use the Output window (View | Output) to view logs and messages from different sources. See View Output Window for more information.