How to: Clear Query Results (Visual Database Tools)
After running a query in the Query and View Designer, you can clear the Results pane. This procedure applies to queries created by using the Open View or Open Table options from Object Explorer. In SQL Server Management Studio, after running a query in the Query Editor, the Results pane cannot be cleared except by closing the Query Editor window or running another query.
Note
This will not undo the changes you've made to the database. For more information about how the Results pane works see Working with Data in the Results Pane (Visual Database Tools).
To clear query results of a view
Right-click in the Results pane, point to Pane, and then click Clear Results.
If a query is being executed when you clear the Results pane, the Query and View Designer stops the query.