Working With Views
A view is simply a SELECT query saved in the database. Thus, most operations you can perform on queries you can also perform on views. However, there are some operations that apply only to one or the other. For background information, see Comparison of Queries and Views.
For details about most of the operations you can perform on views, see Designing Queries. For details about View-specific operations, see the topics listed in the following table.
|Create a view||Creating Views|
|Create an indexed view||Creating Indexed Views|
|Modify an indexed view||Modifying Indexed Views|