Modify Queries (Visual Database Tools)
Applies to: 
SQL Server
Open a query to modify it in Query and View Designer.
To open a query
From the View menu, click Solution Explorer.
In Solution Explorer, right-click the query you want to open and click Open.
To modify the query in Query Designer, highlight the SQL statements, right-click the highlighted area and select Design Query in Editor.
Query Designer is now open and you can make modifications.
See Also
Run Queries (Visual Database Tools)
Work with Data in the Results Pane (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)