Add Table Dialog Box (Query and View Designers)

Lets you add tables, views, user-defined functions, synonyms, or local tables to a query or view.

Note

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

  • Tables
    Lists the tables you can add to the Diagram pane. To add a table, select it and click Add. To add several tables at once, select them and click Add.

  • Views
    Lists the views you can add to the Diagram pane. To add a view, select it and click Add. To add several views at once, select them and click Add.

  • Functions
    Lists the user-defined functions you can add to the Diagram pane. To add a function, select it and click Add. To add several functions at once, select them and click Add. (Applies only to Microsoft SQL Server.)

  • Local Tables
    Lists tables created by queries rather than the ones that belong to the database. (Applies only to Microsoft SQL Server.)

  • Synonyms
    Lists the synonyms you can add to the Diagram pane. To add a synonym, select it and click Add. To add several synonyms at once, select them and click Add. (Applies only to Microsoft SQL Server.)

  • Refresh Button
    Refreshes the list to include any changes made to the database since the list was last retrieved.

  • Add Button
    Adds the selected item or items.

See Also

Other Resources

Designing Queries and Views