Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Open Views 

You can either open the view with either the Open View Definition or Show Results commands.

NoteNote

Creating views and editing the structure of a view is not fully available for connections to some database management systems.

NoteNote

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To open view results in the Results pane

  1. Select a view in Server Explorer.

  2. From the Database menu, click Show Results.

Query and View Designer's Results pane now displays the data that the view retrieves. To display other panes, from the Query Designer menu, point to Pane, and then click the pane you want to open.

To open a view definition

  1. Select a view in Server Explorer.

  2. From the Database menu, click Open View Definition.

NoteNote

By default the Query and View Designer opens all of its panes (SQL, Criteria, Diagram, and Results, but that default can be changed in the Options dialog box. To open these panes if they are closed, from the Query Designer menu, point to Pane, and then click the pane you want to open.

See Also

Community Additions

ADD
Show:
© 2015 Microsoft