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 Import data with the Import Wizard.
Exporting query results to a file or another database. See Export query results.
Running script files. See Run 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.
Viewing execution plans for a query. See Using the Plan Viewer to view graphical plans.
Viewing images, including SVGs. See Viewing images in Interactive SQL.
Viewing spatial data. See View spatial data as images.
Interactive SQL is available on Windows, Solaris, Linux, and Mac OS X, see http://www.sybase.com/detail?id=1061806.
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 http://www.sybase.com/detail?id=1061806.
Starting Interactive SQL
Navigating Interactive SQL
Customizing Interactive SQL
Working with files in Interactive SQL
Backing up .sql files
Executing SQL statements from Interactive SQL
Executing multiple SQL statements
Executing command files
Executing COMMIT and ROLLBACK statements in Interactive SQL
Canceling commands in Interactive SQL
Looking up tables, columns, and procedures
Generating SQL statements from result sets
Editing result sets in Interactive SQL
Using the Query Editor
Using the Expression Editor
Using the Plan Viewer to view graphical plans
Viewing graphical images using the Interactive SQL Spatial Viewer
Viewing images in Interactive SQL
Viewing HTML and XML data in Interactive SQL
Printing SQL statements, execution plans, and result sets
Opening multiple windows
Using source control integration
Interactive SQL SQL statements
Interactive SQL keyboard shortcuts
Interactive SQL options
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|