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. InSQL 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.

System_CAPS_ICON_note.jpg Note


This will not undo the changes you've made to the database. For more information about how the Results pane works see Work 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.

Run Queries (Visual Database Tools)
Stop a Query (Visual Database Tools)
Work with Data in the Results Pane (Visual Database Tools)

Community Additions

ADD
Show: