---
title: "Clear Query Results (Visual Database Tools) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
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: stevestein
ms.author: sstein
manager: craigg
---
# 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[!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)](visual-database-tools.md).  
  
### To clear query results of a view  
  
-   Right-click in the [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)](run-queries-visual-database-tools.md)   
 [Stop a Query (Visual Database Tools)](stop-a-query-visual-database-tools.md)   
 [Work with Data in the Results Pane (Visual Database Tools)](visual-database-tools.md)