Edit

Remove or Delete an Item or Project

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Project items in SQL Server Management Studio projects are Queries, Connections, and Miscellaneous files. You can remove project queries and miscellaneous files from your solution without erasing the files from storage. Remove a project or item when it is not useful in the current solution but you want to include it in another solution.

To remove a project item

  1. In Solution Explorer, select the project item you want to remove.

  2. On the Edit menu, click Remove.

  3. On the confirmation dialog, click Remove to remove the item from the project.

A removed item still exists on the file system. Therefore, you can add a removed item to its original solution or to another solution.

To remove a project

  1. In Solution Explorer, select the project you want to remove.

  2. On the Edit menu, click Remove.

  3. On the confirmation dialog, click OK, to remove the project from the solution.

You can delete a project permanently, but you first need to remove any references to the project from SQL Server Management Studio solutions, and then use Microsoft Windows Explorer to permanently delete the associated files from storage.

To delete a project

  1. In Solution Explorer, remove the project you want to delete from the solution.

  2. In Windows Explorer, locate and select the files associated with the project or item you want to delete.

  3. On the File menu, click Delete.

See Also

Solution Explorer
Add New Items to a Project
Add Existing Items to a Project