SQL Server Management Studio 2012: How to have folders in the SSMS project?
Finally, subfolders were made possible in SSMS 2016.

Cautious users: You can install SSMS 2016 and still keep using old one. See note [1] below.

Once there, start using solutions instead of projects.



Subfoldering works like this:

Adding solution subfolder:


Right-click solution item (tree root) and from menu select Add > New Solution Folder.
Step 1 now works also on any folder you added.


Adding SQL script:


Right-click any folder and from its Add menu, either add existing SQL file or new SQL file (in the list, find item type which has SQL extension).


Your Good old projects (Bad old projects)


You can still host projects in your solution if you see them beneficial for some legacy reasons, for hosting connections, etc.  Just add new or import existing projects into the solution.




[1] Regarding upgrading:


SQL Server 2008 - 2016 are officially supported by SSMS 2016. See more information at download page. For older versions, you can keep your favourite old SSMS, see point 2 below.


the only setting which might require your attention is Options > SQL Server Object Explorer > Script for server version > (set your server version)

Different SSMS versions live well together, i.e. you can have SSMS 2008 and SSMS 2016 installed together without issues – tested.