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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL

Interactive SQL main window description Next Page

Executing SQL statements from Interactive SQL

One of the principal uses of Interactive SQL is to browse table data. Interactive SQL retrieves information by sending a request to your database server. The database server, in turn, looks up the information, and returns it to Interactive SQL.

After you execute a SELECT statement, the result set appears on the Results tab in the Results pane. By default, row numbers appear to the left of the result set.

To execute a SQL statement
  1. Type your query in the Statements pane.

  2. Click Execute SQL Statement, or choose SQL > Execute, or press F5 to execute the statement.

  3. To clear the SQL Statements pane

Executing multiple statements
Recalling commands
Logging commands
Canceling commands in Interactive SQL