Select Table Dialog

Provides a list of database tables for selection for generating SQL queries. Opens when Tables > Open is chosen on the Visual SQL Query Builder dialog.



Setting Description
List box Contains the list of database tables which are available for selection. To select a table, double-click it. A table dialog (for example, maps) opens in the work area on the Select tab of the Visual SQL Query Builder dialog.
Figure 1. Visual SQL Query Builder dialog with a Table dialog
Table dialog (for example, highway) A <TABLENAME> dialog consists of a list of the table's attributes (columns). Double-clicking an attribute enters the attribute into the SELECT clause of the query being generated in the SQL Select Statement text box.
Table List Used to list database tables in the Tables list box.
  • All ? Lists all database tables in the Tables list box.
  • MSCATALOG ? Lists only the MSCATALOG database tables in the Tables list box.
VSQL TABLES OPEN