Share via


Add Table or View Dialog Box

Appears when you select Query or Local View in the New dialog box and then choose New File. In this dialog box, you select one or more existing tables or views on which to base your new query or local view.

  • Database
    Displays the current database by default and lets you select another database.
  • Tables/Views in database
    Displays the tables or views from the current database, depending on whether you select the Tables or Views option.
  • Alias
    Specify an alias instead of the automatically generated alias to use for the table or view you select.
  • Add
    Adds the table or view.
  • Other
    Displays the Open dialog box, from which you can select a free table to add to the query.
  • Tables
    Displays the tables from the current database in the Tables in database box.
  • Views
    Displays the views from the current database in the Views in database box.

See Also

Add Table or View Dialog Box | Join Condition Dialog Box | Arrange Tables and Views Dialog Box | Querying Multiple Tables and Views | New Dialog Box | Open Dialog Box