Contents Index Query Editor Help Tables tab

SQL Anywhere Studio Help
  Query Editor Help

Introducing the Query Editor


The Query Editor is a tool that helps you build Adaptive Server Anywhere 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 Interactive SQL for processing.

The Query Editor provides a series of tabs that guide you through the components of a SQL query, most of which are optional. The tabs are presented in the order that SQL queries are usually built:

The Query Editor also contains

Each component of the Query Editor has context-sensitive online help that describes how to use the tab, and provides links into the Adaptive Server Anywhere documentation that explains relevant concepts and usage.

Using the Query Editor 

To open the Query Editor, open Interactive SQL, connect to a database, and click Tools > Edit Query. If you have SQL code selected in Interactive SQL, the selected code is automatically imported into the Query Editor.

When you finish creating a query in the Query Editor, click OK to write the query to the Interactive SQL Statements pane.

You do not need to use SQL code to create queries with the Query Editor. However, you can use SQL with the Query Editor in the following ways:

Query Editor limitations 

The Query Editor builds Adaptive Server Anywhere SELECT statements. It is not designed to create views, although you can create them in Interactive SQL and reference them in the Query Editor. Nor was it designed to create update statements or other non-SELECT SQL statements. It creates a single SELECT statement, so it does not build unions or intersects of SELECT statements. In addition, the Query Editor does not support Transact-SQL syntax.

More information 

Contents Index Query Editor Help Tables tab