Edit

Share via


Delete queries (Visual Database Tools)

Applies to: SQL Server

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

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, select Remove.

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

Note

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