To open the Query and View Designer for a view In Object Explorer, right-click the view you want to open and click Design or Open View. If you chose Design, the Query and View Designer panes open as dictated by the options selected in the Options dialog box.
How do I get to the query design view?
To make further changes to the query, click Home > View > Design View to switch back to Design view. Change your fields, expressions, or criteria and rerun the query until it returns the data that you want.
How do I open a SQL view?
To view the SQL, go to the Home tab. Select SQL View from the View menu and you will see the SQL of your query.