Move Items in a Solution
Project items in SQL Server Management Studio projects are Queries, Connections, and Miscellaneous files. You can move Queries and Miscellaneous Files between projects in Solution Explorer, but Connections cannot be moved.
To move items in Solution Explorer
In Solution Explorer, select the item you want to move.
On the Edit menu, click Cut.
In Solution Explorer, select the destination.
On the Edit menu, click Paste.
You can move items by dragging Query and Miscellaneous files within Solution Explorer. Dragging allows you to see the outcome of the drag operation. Moving queries from one project type to another may cause queries to be considered as miscellaneous files in the target project.
Moving a connected query does not move the connection to the target project. The query will lose its connection after it is moved to the target project.