Editing a SQL File

Edit a SQL file using Content Assist or Visual SQL .

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

    The SQL file displays in the SQL File Editor and a connection state, connected or not connected, is displayed in the status bar at the bottom left edge of the Workbench from the context menu.

  2. To change the connection profile with which the SQL file is associated, select a connection profile type, connection profile name, and database from the corresponding drop-down menus.

    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. To display line numbers for the SQL code, right-click in the left margin, and choose Show Line Numbers from the context menu.
  4. Edit the SQL file using content assist or Visual SQL, or enter edits manually.
  5. (Optional) To remove edits since your last save, select File > Revert.
  6. Save the file to its project when you are done editing.
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

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.