CODEWITHSUNDEEP
sql-serverssms-17
N.MORR
N.MORR

Reputation: 525

SQL Server Management Studio 2017 Database Diagram Folder Missing

I have SSMS 2017 installed and I want to use it to create an ERD for some of my databases. The documentation online says you just need to right click on the "Database Diagrams" folder under your database in the navigation panel. However, that folder is simply not there for any of my databases. I cannot find any fix or work around. Does anyone have any ideas on how to fix this?

Upvotes: 12

Views: 13423

Answers (3)

Jason Goble
Jason Goble

Reputation: 31

SSMS 18.0 did indeed have the Database Diagrams removed. Brent Ozar wrote an article about this very issue, although his perspective was much more positive on their removal. However, as @cOborski commented, the feature is back in SSMS 18.1.

Upvotes: 1

cOborski
cOborski

Reputation: 134

The SQL 2017 documentation has a page explaining how to use database diagrams which conflicts with the release notes that @squillman posted. I've opened an issue with Microsoft docs about it.

EDIT: Do to feedback, Microsoft is returning this feature in release 18.1.

Upvotes: 0

PausePause
PausePause

Reputation: 806

Posting this answer here so the post isn't recorded as "Unanswered".

User squillman posted in the comments that in SSMS version 18.0 database diagrams are deprecated an alternate solutions for database diagrams should be sought.
Personally I like Visio, it's pretty straightforward to use, even if it isn't the most effective tool.

Be sure to vote for squillman's comment.

Upvotes: 0

Related Questions