Menu
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?
964
To open a database diagramDouble-click the name of the database diagram you want to open. Right-click the name of the database diagram you want to open, and then choose Design Database Diagram.
To create a new database diagramIn Object Explorer, right-click the Database Diagrams folder or any diagram in that folder. Choose New Database Diagram on the shortcut menu. The Add Table dialog box appears. Select the required tables in the Tables list and click Add.
The Latest and Greatest Version 18 iterates off of this and is based on the Visual Studio 2017 shell. Regardless of the edition being used, SQL Server Management Studio only comes in one flavor and boasts backwards compatibility with almost all features from versions 2008 to 2019, including SQL Azure support.
Download SQL Server Management Studio (SSMS) 18.12.11 is the latest general availability (GA) release of SSMS. If you need a previous version of SSMS, see previous SSMS releases.
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
99
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.
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
