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
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.
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.