How to access the Query Designer to design a view (Enterprise Manager)

To access the Query Designer to design a new view

1. Expand a server group; then expand a server.
2. Expand Databases, then expand the database in which the view will be created.
3. Right-click Views and right-click New View....

The Query Designer will open with all four view panes visible. To hide panes, see How to hide panes in the Query Designer (Enterprise Manager).

To access the Query Designer to design an existing view

1. Expand a server group; then expand a server.
2. Expand Databases, and then expand the database containing the view.
3. Right-click the view, then select Design View.

The Query Designer will open with only the Results pane visible. To hide panes, see How to hide panes in the Query Designer (Enterprise Manager).

To access the Query Designer to see the data in a view

1. Expand a server group; then expand a server.
2. Expand Databases, then expand the database containing the view.
3. Right-click the view, then select Return all Rows or Return Top....

The Query Designer will open with all four view panes visible. To view the other panes, see How to open panes in the Query Designer (Enterprise Manager).