Editing a SQL File

Edit a SQL file using Content Assist or Visual SQL.

  1. In WorkSpace Navigator, right-click the SQL file that you want to edit in and select Open.

    The connection state displays in the status bar.

  2. (Optional) Change the connection profile with which the SQL file is associated, select a connection profile type, connection profile 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) Display line numbers for the SQL code by right-clicking in the left margin and selecting Show Line Numbers.
  4. Edit the SQL file by manually editing the SQL code, or by using Content Assist or Visual SQL.
  5. (Optional) Remove edits since your last save by selecting File > Revert.
  6. Save the file to its project or a new project.
Related concepts
SQL File 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

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com