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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools

 

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:

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:


Starting Interactive SQL
Navigating Interactive SQL
Executing SQL statements from Interactive SQL
Inserting comments
Indenting SQL statements
Looking up tables, columns, and procedures
Generating SQL statements from result sets
Using the Query Editor
Viewing plans using the Interactive SQL Plan Viewer
Printing SQL statements, execution plans, and result sets
Editing result sets in Interactive SQL
Opening multiple windows
Using source control integration
Interactive SQL keyboard shortcuts
Interactive SQL options