|
|
|
|
Executing a SQL File
You can execute a SQL file from the SQL File Editor or from
WorkSpace Navigator.
Prerequisites
Make sure the database server is running and you are connected to it through a connection profile.
Execute the SQL
file using one of the following methods.
Option |
Description |
From SQL File Editor
|
-
In the WorkSpace Navigator project folder, double-click to open the SQL file in SQL File Editor.
-
Right-click in the editor, and select
Execute All.
|
From WorkSpace Navigator
|
-
Select one or more SQL files.
-
Right-click the
files and choose
Execute SQL File.
-
If you selected multiple SQL files, click OK in the Select Profiles for the File dialog.
|
From the toolbar
|
-
Click the
Choose One or More SQL Files to Execute
button on the Database
Development perspective toolbar.
-
On your file system, navigate to your workspace and project.
-
Select the SQL
files you want to execute from the file system, and click
Open.
-
Select the Database Server Type, Connection Profile Name, and Database Name.
-
(Optional) If you
did not create a connection profile for this database type, click
Create.
-
Click
OK.
|
The SQL file executes, and results appear in the SQL Results view.
SQL Results view
displays the result sets, database server messages,
execution status (success or failure) and operation details.
|
|
|