Interactive SQL windows

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, export a result set, and save files and connection information as favorites.

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 Looking up tables, columns, and procedures in Interactive SQL.
Lookup Procedure Name The Lookup Procedure Name window lets you browse procedure names and insert them into the SQL Statements pane. See Looking up tables, columns, and procedures in Interactive SQL.
Edit Query The Query Editor provides a graphical way to create and edit SELECT statements in Interactive SQL. See Query Editor in Interactive SQL.
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 Obtaining Index Consultant recommendations for a query.
Plan Viewer The Plan Viewer is a graphical tool for viewing graphical plans for SQL Anywhere databases and text plans for UltraLite databases. See Plan Viewer and graphical plans in Interactive SQL.
Spatial Viewer The Spatial Viewer is a graphical tool for viewing spatial data. See Viewing spatial data as images (Interactive SQL).
Options The Options window sets options for commands, appearance, importing and exporting data, and messages in Interactive SQL.

The Data menu contains the following windows:

Export Opens the Export Wizard, which allows you to export a result set. See Export data with the Export Wizard.
Import Opens the Import Wizard, which allows you to import data from a file or database. See Import data with the Import Wizard (Interactive SQL).

The Favorites menu contains the following windows:

Add To Favorites This window allows you to save SQL files, SQL statements, and connection information as favorites. See Saving SQL script files and connections in a favorites list.
Organize Favorites This window allows you to maintain and organize your favorites. See Saving SQL script files and connections in a favorites list.
Import Favorites This window allows you to import favorites from a .fav file. See Sharing favorite SQL script files and connections.
Export Favorites This window allows you to export favorites to a .fav file. See Sharing favorite SQL script files and connections.
Show Favorites Opens the Favorites window on the left side of the Interactive SQL window. See Saving SQL script files and connections in a favorites list.

Discuss this page in DocCommentXchange.