Editing a SQL File

Edit the SQL statements in a SQL file.

1. In WorkSpace Navigator, double-click the SQL file to open it in SQL File Editor.
2. (Optional) Change the connection profile Type, Name, and/or Database.

   Associating a SQL file with the connection profile of a connected data server enables you to use the full capabilities of Content Assist and to execute the SQL file or selected statements.

3. (Optional) Right-click in the left margin and select Show Line Numbers.
4. Edit the SQL file by manually editing the SQL code or by launching Visual SQL SQL Query Builder.
5. (Optional) Remove edits since your last save by right-clicking and selecting Revert File.
6. Save the file to the project or to a new project.