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.
Note
Creating views and editing the structure of a view is not fully available for connections to some database management systems.
In This Section
How to: Create Views
Provides steps for creating a view to be saved with the database for reuse.How to: Open Views
Provides steps for how to open the view definition or just the results returned by the view.How to: Save Views
Provides steps for saving a modified or new view.How to: Rename Views
Provides steps for copying a view definition and pasting it into a view with a different name.How to: Delete Views from Databases
Provides steps for deleting a view from Server Explorer and the database.How to: Show View Properties
Provides steps for opening the Properties window for a view.
Reference
- Reference (Visual Database Tools)
Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.
Related Sections
Designing Queries and Views
Provides links to topics covering the use of the Query and View Designer.View Properties (Visual Database Tools)
Describes each of the properties available for a view.