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.