Share via


How to: Open Views

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

Note

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

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

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.

Note

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

Concepts

Working with Data in the Results Pane

Other Resources

Working with Views