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

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. 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