# 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.

Related concepts
SQL File Editor
SQL Scrapbook
Related tasks
Creating a SQL File
Opening a SQL File
Saving a SQL File
Executing a SQL File
Related reference
SQL Editor Preferences
Code Assist Preferences
SQL Files/Scrapbooks Preferences
Syntax Coloring Preferences
Templates Preferences