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
In Server Explorer, right-click the Views node, then choose Add New View from the shortcut menu.
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.