Skip to content

Latest commit

 

History

History
41 lines (32 loc) · 1.74 KB

File metadata and controls

41 lines (32 loc) · 1.74 KB
title Delete Queries (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
dropping queues
deleting queries
removing queries
queries [SQL Server], deleting
ms.assetid 084e1504-3d2f-4bd9-b97c-b9c8c874751c
author stevestein
ms.author sstein
manager craigg

Delete Queries (Visual Database Tools)

You can delete a query, removing it from the project and permanently deleting it from the file system. Queries deleted using the following procedure are not sent to the Recycle Bin and cannot be recovered.

To permanently delete a query

  1. From the View menu, choose Solution Explorer.

  2. In Solution Explorer, select the query you want to permanently delete.

  3. Right-click the query and from the shortcut menu, click Remove.

  4. In the Microsoft SQL Server Management Studio dialog box, click Delete.

Note

If you want to remove the query from the project without deleting it, click Remove. Then you can right-click the query folder and choose Add Item to find and add the query back later.

See Also

Clear Query Results (Visual Database Tools)
Discard Changes Made to Queries (Visual Database Tools)
Design Queries and Views How-to Topics (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)