---
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)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.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 [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)], 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)](../../ssms/visual-db-tools/work-with-data-in-the-results-pane-visual-database-tools.md).  
  
### To clear query results of a view  
  
-   Right-click in the [Results pane](../../ssms/visual-db-tools/results-pane-visual-database-tools.md), 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)](../../ssms/visual-db-tools/run-queries-visual-database-tools.md)  
[Stop a Query (Visual Database Tools)](../../ssms/visual-db-tools/stop-a-query-visual-database-tools.md)  
[Work with Data in the Results Pane (Visual Database Tools)](../../ssms/visual-db-tools/work-with-data-in-the-results-pane-visual-database-tools.md)