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:

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.

 SQL statements used only from Interactive SQL

Starting Interactive SQL
Navigating Interactive SQL
Customizing Interactive SQL
Working with files in Interactive SQL
.sql file backups in Interactive SQL
Executing SQL statements in Interactive SQL
Executing multiple SQL statements in Interactive SQL
SQL script files in Interactive SQL
Executing COMMIT and ROLLBACK statements in Interactive SQL
Recalling statements in Interactive SQL
Statement logging in Interactive SQL
Statement canceling in Interactive SQL
Looking up tables, columns, and procedures in Interactive SQL
Generating SQL statements from result sets in Interactive SQL
Result sets in Interactive SQL
Query Editor in Interactive SQL
Expression Editor in Interactive SQL
Plan Viewer and graphical plans in Interactive SQL
Spatial Viewer and graphic images in Interactive SQL
Interactive SQL and graphical images
Viewing HTML and XML data in Interactive SQL
Printing SQL statements, execution plans, and result sets in Interactive SQL
Opening multiple Interactive SQL windows
Source control integration in Interactive SQL
SQL statements for Interactive SQL
Keyboard shortcuts for Interactive SQL
Interactive SQL options