Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL


Query Editor in Interactive SQL

The Query Editor is a tool in Interactive SQL that helps you build SELECT statements. You can create SQL queries in the Query Editor, or you can import queries and edit them. When you have finished your query, click OK to export it back into Sybase Central or Interactive SQL for processing.

 Create a query using the Query Editor
  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 Interactive SQL SQL Statements pane.

 Using SQL statements with the Query Editor
 Configuring the Query Editor
 Query Editor tabs
 Query Editor tools
 Query Editor limitations
 See also