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 Editor
Content Assist
Related tasks
Creating a SQL File
Opening a SQL File
Saving a SQL File
Saving a SQL File As a Template
Related reference
SQL File Editor Toolbar
Bookmarks view

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com