Working With Views

Visual Database Tools

Visual Database Tools

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.

To See
Create a view Creating Views
Create an indexed view Creating Indexed Views
Modify an indexed view Modifying Indexed Views