You can execute a SQL file from the SQL Editor and from the Navigator View.
Execute the SQL using one of the following methods.
Option
Description
From SQL Editor
Open the SQL file from the
Navigator project folder in which it is stored by right-clicking
the file and choosing
Open With > SQL File Editor
from the context menu.
In SQL Editor, right-click in the file content, and select
Execute All from the context menu.
The SQL Results view displays the result sets, database server messages, execution status (success or failure) and operation details.
Note: If the SQL file is not connected to the connection profile with which it is associated,
Execute All is disabled.
From the Navigator view
Right-click the file in the Navigator View, and choose Open With > SQL File Editor
from the context menu.
In SQL Editor, right-click in the file content, and select
Execute All from the context menu.
The SQL Results view displays the result sets, database server messages, execution status (success or failure) and operation details.
The SQL file executes, and results appear in
the SQL Results view.