You can access all the windows in Interactive SQL through the Tools, Data, and Favorites menus. With these windows, you can configure Interactive SQL settings, search for table and procedure names to insert into your queries, edit your queries, and export a result set.
The Tools menu contains the following windows:
Lookup Table Name The Lookup Table Name window lets you browse table and column names and insert them into the SQL Statements pane. See Lookup Table Name window.
Lookup Procedure Name The Lookup Procedure Name window lets you browse procedure names and insert them into the SQL Statements pane. See Lookup Procedure Name window.
Edit Query The Query Editor provides a graphical way to create and edit SELECT statements in Interactive SQL. See Query Editor introduction.
Index Consultant The Index Consultant guides you in the proper selection of indexes. You can use the Index Consultant to analyze the benefits of indexes for an individual query. See Using the Index Consultant.
Plan Viewer The Plan Viewer is a graphical tool for viewing graphical plans for SQL Anywhere databases and text plans for UltraLite databases. See Viewing plans using the Interactive SQL Plan Viewer.
Options The Options window sets options for commands, appearance, importing and exporting data, and messages in Interactive SQL. See Options window: General tab.
The Data menu contains the following windows:
Export Opens the Export Wizard, which allows you to export a result set. See Using the Interactive SQL Export Wizard.
Import Opens the Import Wizard, which allows you to import data from a file or database. See Using the Interactive SQL Import Wizard.
The Favorites menu contains the following windows:
Add to Favorites This window allows you to save SQL files and connection information as favorites.
Organize Favorites This window allows you to maintain and organize your favorites.
Show Favorites Opens the Favorites window on the left side of the Interactive SQL window.
Lookup Procedure Name window
Lookup Table Name window
Options window: General tab
Options window: Import/Export tab
Options window: Messages tab
Options window: Source Control tab
Options window: Toolbar tab
Options window: Editor tab
Options window: SQL Anywhere tab or Options window: UltraLite tab
Add to Favorites window
Organize Favorites window
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |