v1.7-beta - SSMS 21 Preview

SSMS 21 is now using Visual Studio 2022 and the Visual Studio Installer. Download SSMS 21 Preview

Adding support for 21 required removing support for 17 and earlier.

Install

You must unblock the zip file before extracting. Right click on the zip file in Windows Explorer and select Properties.
If you see an Unblock button or checkbox then click it.

Extract the zip file and copy the SSMS Schema Folders folder into the SSMS extension folder.

The default path for installation with the current preview version is C:\Program Files\Microsoft SQL Server Management Studio 21\Preview\Common7\IDE\Extensions.

v1.6 - SSMS 20

Install

If you are in a shared environment and don't want to force others to use this extension then download the 'Disabled by default' version. After installing go to the options to enable it or hold your selected modifier key (default ctrl) to enable it on single folders.

You must unblock the zip file before extracting. Right click on the zip file in Windows Explorer and select Properties.
If you see an Unblock button or checkbox then click it.

Extract the zip file and copy the SSMS Schema Folders folder into the SSMS extension folder. Remove or replace any previous version. For 2012-17 run the included reg file to skip the load error or click No when you do see the error and then restart SSMS.

• 2012 - C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
• 2014 - C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions
• 2016 - C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions
• 17 - C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions
• 18 - Default install location is C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions
• 19 - Default install location is C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions
• 20 - Default install location is C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions

SSMS 18 and above allow installing in a different location. If the path above does not exist then you need to find the correct path to use.

Change Log

v1.6 (2024-04-12)

• Added support for v20.
• Added enabled modifier keys.
• Fixed: Timeout on initial Azure connection.

v1.5 - SSMS 19.1

Install

If you are in a shared environment and don't want to force others to use this extension then download the 'Disabled by default' version. After installing go to the options to enable it. (#24)

You must unblock the zip file before extracting. Right click on the zip file in Windows Explorer and select Properties.
If you see an Unblock button or checkbox then click it.

Extract the zip file and copy the SSMS Schema Folders folder into the SSMS extension folder. Remove or replace any previous version. For 2012-17 run the included reg file to skip the load error or click No when you do see the error and then restart SSMS.

• 2012 - C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
• 2014 - C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions
• 2016 - C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions
• 17 - C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions
• 18 - Default install location is C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions
• 19 - Default install location is C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions

SSMS 18 and 19 allow installing in a different location. If the path above does not exist then you need to find the correct path to use.

Change Log

v1.5 (2023-05-26)

• Added support for v19.1. (#32)
• Added second folder level for alphabetical or sub schema sorting. (#2 #27)

v1.4 (2022-07-28)

• Added support for v19.0 (preview 2).
• Language localisation for options. (Thank you @micjahn)
• Performance improvements and options for very large databases. (#22)
• Fixed: Incorrect folder name when schema contains a dot. (#27)

v1.4-beta2

This beta release adds a second folder level. There are known bugs in this. The folder levels don't work with the Use Node.Clear option and it can end up in weird half sorted list when the node count is close to the min node options.

This has been compiled with the default options for double schema (#2 #27). Current plan is to do final release with second level as alphabetical and min node count 200.

Install instructions are in the readme. Don't forget to unblock before extracting.

v1.4-beta SSMS 19

Beta release with support for SSMS 19 (preview 2) and changes for issues #22 #26 #27.

Folder levels #2 coming soon.

v1.3.1 - SSMS 18.0

Install

You may need to unblock the zip file before extracting. Right click on the zip file in Windows Explorer and select Properties.
If you see an Unblock button or checkbox then click it.

Extract the zip file and copy the folder into the SSMS extension folder. Remove or replace any previous version.
Run the included reg file to skip the load error.

• 2012 - C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
• 2014 - C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions
• 2016 - C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions
• 17 - C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions
• 18 - C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions

Change Log

v1.3.1 (2018-10-06)

• Added support for v18.0 (preview 4).

v1.3 (2018-06-28)

• Auto expand schema node when only one.
• Improved performance.
• Added option to remove schema name from object node label.

v1.3

Install

You may need to unblock the zip file before extracting. Right click on the zip file in Windows Explorer and select Properties.
If you see an Unblock button or checkbox then click it.

Extract the zip file and copy the folder into the SSMS extension folder. Remove or replace any previous version.
Run the included reg file to skip the load error.

• 2012 - C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
• 2014 - C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions
• 2016 - C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions
• 17 - C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions

Change Log

v1.3 (2018-06-28)

• Auto expand schema node when only one.
• Improved performance.
• Added option to remove schema name from object node label.

v1.2.1

v1.2.1 (2016-12-22)

Depending on your web browser, you may need to unblock the zip file before extracting.
Right click on the zip file and select Properties.
If you see an Unblock button or checkbox then click it.

Extract the zip file and copy the folder into the SSMS extension folder. Remove or replace any previous version.
Run the included reg file to skip the load error.

• 2012 - C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions
• 2014 - C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions
• 2016 - C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions
• 17 - C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions