SSMS version 18 – no Database Diagrams

Sql ServerSsmsSsms 18

Sql Server Problem Overview

I notice that Database Diagrams are not supported in SSMS version 18, any idea why, and is there a way to get the same functionality?

And why is the T-SQL debugger gone now?

Sql Server Solutions

Solution 1 - Sql Server

As it was posted at June 11, 2019, to announce that SQL Server Management Studio (SSMS) 18.1 is now generally available, the Database diagrams is back in SSMS 18.1 along side SSBDIAGNOSE.EXE and Integration Services (SSIS)

Original Answer:

The feature is deprecated, you can visit SQL Server Management Studio - Changelog (SSMS) page and read the Deprecated Features in SSMS 18.0.

>### Deprecated Features > >The following features are no longer available in SSMS: > >- T-SQL Debugger >- Database Diagrams > - …

Those features are available in earlier versions, you can use one of them a long side with SSMS 18.0

Solution 2 - Sql Server

SQL Server Management Studio 18.1 was just released on June 11th, and it supports Database Diagrams again.

According to this blogpost SQL Server Management Studio (SSMS) 18.1 is now generally available:

> Yes, we’ve heard the feedback; Database Diagrams is back.

Here's the SSMS download page.

Solution 3 - Sql Server

I had the same problem with SSMS 18 (preview 4)

To get the functionality, install a previous SSMS release until the fix comes.

Download SSMS 17.8.1

Solution 4 - Sql Server

SQL Complete now has T-SQL debugger feature for SSMS v18.


All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionBrian BattlesView Question on Stackoverflow
Solution 1 - Sql ServerIlyesView Answer on Stackoverflow
Solution 2 - Sql ServerNiklasView Answer on Stackoverflow
Solution 3 - Sql ServerIvan KukushkinView Answer on Stackoverflow
Solution 4 - Sql Servervik_78View Answer on Stackoverflow