clear-query-results-visual-database-tools.md

title	Clear Query Results
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	result sets [SQL Server], queries results [SQL Server], query queries [SQL Server], results Results pane clearing query results
ms.assetid	4ed9692e-5170-47d4-8b0b-028c967d47ff
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Clear Query Results (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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 [!INCLUDEssManStudioFull], 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 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.

See Also

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