Table Types Dialog |
The Table Types dialog, accessible from the Table Types button on the Tables tab of the Database Connection Setup dialog, allows you to select the types of tables that are to be read from the data source.
Table Types
TABLE. A collection of rows, containing data sets.
VIEW. An alternative way of looking at the data in one or more tables. A view is usually created as a subset of the columns from one or more tables. Views are generally equivalent to tables.
SYSTEM TABLE. A table that is used to store information about a specified system (the system catalog) or a specified database (the database catalog). The system catalog is comprised of system tables found exclusively in the master database. Within Microsoft Access, system tables are hidden, except when system objects are visible. Excel uses System Tables to list its data.
SYSTEM VIEW. An alternative way of viewing one or more system tables. Not available with ODBC.
GLOBAL TEMPORARY. A table that is visible to all data source connections. These data sources need not be dedicated to a user or local to a computer.
LOCAL TEMPORARY. A table that is only visible to the data source connection that created it.
ALIAS. A pseudonym given to a field, table or database. This is useful when a field or table's name has been changed, and the user is attempting to track references to the field or table. In other words, an alias gives the user an opportunity to amend discrepancies in naming conventions. (Driver specific).
SYNONYM. Identical tables given different names. (Driver specific).
Enter Table Names by Hand Only. When enabled, requires the user to enter table names manually in order to use their contents inside of
Related Topics