Share via


How to: Create Views

Because a view is saved in the database and a query is not, the process of creating a new view is different from the process of creating a query.

Note

Creating views and editing the structure of a view is not fully available for connections to some database management systems.

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.

To create a view

  1. In Server Explorer, right-click the Views node, then choose Add New View from the shortcut menu.

  2. Proceed to design the view as you would design a SELECT query.

    Note

    Although you can design the view as you would design a SELECT query, there are some restrictions. For more information, see Comparison of Queries and Views.

See Also

Other Resources

Working with Views