Creating a SQL File

Use Database Development tools to create SQL files.

You can use an existing project to store the SQL file or create a project when you create the SQL file.

In the Database Development perspective, select File > New > SQL File.
The New SQL File wizard opens.

Associate the SQL file with a project.

To	Do this
Use an existing project	Enter or select the project name in the Enter or Select the Parent Folder field.
Create a new project	Click Create Project, and follow the wizard instructions.

Type the SQL file name in the field above the Advanced button.
(Optional) Click Advanced to link to a file in the file system and to create, edit, or remove defined path variables.
(Optional) Select a connection profile type from the Connection profile type drop-down list.
(Optional) Select from the Connection profile name drop-down list.

Note: If the a connection profile does not appear, click Create to create a new connection profile.
(Optional) Narrow your database selection in the Database Name field.
(Optional) Select the Do not connect now check box if you do not want to connect to the server.
You cannot use the complete content assist feature if this check box is selected.
Click Finish.
A SQL file is created under the project in the WorkSpace Navigator. The cursor moves to either the empty SQL file in the editor or to the beginning of the file if you linked it to an existing file.
(Optional) Right-click in the SQL File Editor and select Visual SQL to enter SQL statements, or type your SQL in the content window.
Use Content Assist to edit the SQL statement.
To add or remove comment delimiters for a line of code, right-click the line of code, and select Toggle Comment from the context menu. To add or remove comment delimiters for multiple lines, highlight the lines, right-click in the selection, and select Toggle Comment from the context menu.
Right-click in the editor window and select Save File to save your changes.