Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL » Query Editor in Interactive SQL

 

Creating a query using the Query Editor

You can use the Query Editor in Interactive SQL to build SELECT statements. You can create SQL queries in the Query Editor, or you can import queries and edit them.

Prerequisites

There are no prerequisites for this task.

 Task

  1. Connect to a database from Interactive SQL.

  2. Open the Query Editor.

    Click Tools » Edit Query.

    If you have a SQL statement selected in Interactive SQL, the selected statement is automatically imported into the Query Editor.

  3. Create your query.

    At any time while using the Query Editor, you can click SQL at the bottom of the window to see the SQL statement for the query you are building. You can directly edit the code, and the fields are automatically updated in the Query Editor user interface.

  4. Click OK to write the query to the SQL Statements pane.

Results

A query is created using the Query Editor, and is exported to Interactive SQL for processing.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0