|
Interactive SQL is a tool shipped 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. See Exporting query results.
Running command files or script files. See Running SQL command files.
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 Help.
Interactive SQL is available on Windows, Solaris, Linux, and Mac OS X.
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
Interactive SQL main window description
Executing SQL statements from Interactive SQL
Using Interactive SQL with command files
Looking up tables, columns, and procedures
Printing SQL statements
Editing result sets in Interactive SQL
Opening multiple windows
Source control integration
Interactive SQL keyboard shortcuts
Interactive SQL options