Reputation: 31
In SQL Server Management Studio 2017, while creating a new database diagram or updating the existing one, the default Table View type is Column Names.
But when I try to change the table view type, it gets changed to STANDARD irrespective of what table view type I have selected. Then if I try to change it back to Column Names, nothing happens. It remains stuck at STANDARD table view type.
I have tried repairing my SSMS and VS installations but nothing worked so far.
Any advice please ?
Upvotes: 3
Views: 1436
Reputation: 166
While this issue is still existing, you can change the "Default table view" in
Tools > Option > Designers > Table and Database Designers
Then when you add new tables they will be the desired layout, without changing the ones previously added.
Upvotes: 0
Reputation: 113
We are having the exact same problem with SSMS v17.1 (14.0.17119.0) The only solution we have found is to remove the table from the diagram and re-add it.
Upvotes: 3