Share via


How to: Open Views (Visual Database Tools)

You can either open the view with either the Modify or Open View commands.

To open view results in the Results pane

  1. In Object Explorer, right-click a view and click Open View.

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. In Object Explorer, right-click a view and click Design (Modify in SP1 or earlier).

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 (Visual Database Tools)

Other Resources

Working with Views (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance