SQL Server Management Studio 2017 Database Diagram Folder Missing

sql-server ssms-2017
N.MORR picture N.MORR · Oct 12, 2018 · Viewed 10.5k times · Source

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?

Answer

Jason Goble picture Jason Goble · Jul 16, 2019

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.

Related questions

Activity Monitor always Paused in SSMS 17.8.1

Whenever I open the Activity Monitor in SQL Server Management Studio 17.8.1(14.0.17277) the overview always switches to (paused). Even if I choose resume, it quickly changes back to paused. This happens on a variety of SQL Servers and SQL Server versions (2005 …

Read More
Default Value for DATETIME column in SQL Server Management Studio 2017

Is it possible to create a table with a column that has type DATETIME and give it a default value such as CURRENT_TIMESTAMP or GETDATE()? Is there another way to do this? Screenshot from SSMS 2017

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More