Using 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 from Interactive SQL.
Browsing the information in a database. See Executing SQL statements from Interactive SQL.
Editing data in result sets. See Editing result sets in Interactive SQL.
Loading data into a database. See Using the Interactive SQL Import Wizard.
Exporting query results to a file or another database. See Exporting query results.
Running script files. See Running SQL command 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 Using the Query Editor.

Interactive SQL is available on Windows, Solaris, Linux, and Mac OS X, see [external link] SQL Anywhere Supported Platforms and Engineering Status.

SQL statements used only from Interactive SQL

Interactive SQL supports all SQL statements supported by SQL Anywhere and UltraLite databases, as well as several SQL statements that can be used only from Interactive SQL: