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.

  • Lookup Procedure Name   The Lookup Procedure Name window lets you browse procedure names and insert them into the SQL Statements pane.

  • Edit Query   The Query Editor provides a graphical way to create and edit SELECT statements in Interactive SQL. See Using the Query Editor.

  • 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 Obtain 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 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.

The Data menu contains the following windows:

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.