Clever Geek Handbook

SSMS 17 Database Diagram Table Table View Type Does Not Work

In SQL Server Management Studio 2017, when creating a new database diagram or updating an existing one, the default table type is the column names.

But when I try to change the type of the table view, it changes to STANDARD no matter what type of table view I choose. Then, if I try to change it to column names, nothing happens. It remains stuck in STANDARD table view.

I tried to repair my SSMS and VS installations, but nothing worked so far.

Any advice please?

+3


source to share


2 answers


We have the same problem with SSMS v17.1 (14.0.17119.0) The only solution we found was to remove the table from the diagram and add it again.



+3


source


While this problem still exists, you can change the "default table view" in

Tools> Option> Designers> Table and Database Designers



Then, when you add new tables, they will be in the desired layout without changing the previously added ones.

0


source






More articles:


All Articles