Working with Views (Visual Database Tools)

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 Views (Database Engine).

In This Section

• How to: Create Views (Visual Database Tools)
  Provides steps for creating a view to be saved with the database for reuse.

• How to: Open Views (Visual Database Tools)
  Provides steps for how to open the view definition or just the results returned by the view.

• How to: Save Views (Visual Database Tools)
  Provides steps for saving a modified or new view.

• How to: Rename Views (Visual Database Tools)
  Provides steps for copying a view definition and pasting it into a view with a different name.

• How to: Delete Views from Databases (Visual Database Tools)
  Provides steps for deleting a view from Object Explorer and the database.

• How to: Show View Properties (Visual Database Tools)
  Provides steps for opening the Properties window for a view.

Related Sections

• Designing Queries and Views (Visual Database Tools)
  Provides links to topics covering the use of the Query and View Designer.