Interactive SQL

Interactive SQL is a tool included with SQL Anywhere that lets you execute SQL statements, build scripts, and display database data for both SQL Anywhere and UltraLite databases. You can use Interactive SQL for:

Sending SQL statements to the database server. See Executing SQL statements in Interactive SQL.
Browsing the information in a database. See Executing SQL statements in Interactive SQL.
Editing data in result sets. See Result sets in Interactive SQL.
Loading data into a database. See Import data with the Import Wizard (Interactive SQL).
Exporting query results to a file or another database. See Exporting query results.
Running script files. See Run SQL script files in Interactive SQL.
Running the Index Consultant, a tool that helps you improve query performance. See Index Consultant.
Accessing the Query Editor, a tool that helps you design, analyze, and test all kinds of queries. See Query Editor in Interactive SQL.
Viewing execution plans for a query. See Plan Viewer and graphical plans in Interactive SQL.
Viewing images, including SVGs. See Interactive SQL and graphical images.
Viewing spatial data. See Viewing spatial data as images (Interactive SQL).

Interactive SQL is available on Windows, Solaris, Linux, and Mac OS X, see [external link] http://www.sybase.com/detail?id=1061806.

Note

The administration tools only run on Intel-based Macintosh computers with 64-bit processors supported by the Apple JDK 1.6 (Mac OS X 10.5.2 or later). See [external link] http://www.sybase.com/detail?id=1061806.

Interactive SQL

Note

SQL statements used only from Interactive SQL