MicroStation CONNECT Edition Help

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.



SettingDescription
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.


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.
Note: A maximum of 50 tables may be open at one time.
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