Help on Table Properties

You can include existing database tables or fields in a project one by one (rather than having them extracted automatically for you). For example, use this command when you’ve added a table to your database structure and you want to make it available to your Microsoft English Query application. (You can also select tables independently by choosing the Import New Tables command on the File menu.)

Use this To do this
Table name Select the table you want to add to the project.
Fields Specify the fields in the table that you want to add to the project.
Keys/Specify Keys Enter the fields that constitute the primary key. You can type the key names, separated by commas, or select them by clicking Specify Keys.
Show Entities Display a list of entities that use this table.
Refresh Display new field, key, and join information for the table. Use this option when changes have been made in the database. Deletions and additions to the table are displayed when you refresh the table, including:
  • If the table or a field is no longer in the database, it is deleted from the project.
  • If the table or field has been added to the project, it will be displayed in the project.
  • Field data types and null status is updated in the project
  • Joins in the database are added to the project if possible (addition of joins might require refreshing the target table first).
Module Specify the module (.eqm file) of which you want the current table to be a part.


(c) 1996-1998 Microsoft Corporation. All Rights Reserved.