All geek questions in one place

How to update a database diagram in Microsoft SQL Server Management Studio

I currently have a database chart window open in Microsoft Server Management Studio 2014. Is there a way to “refresh” the view so that I can see the newly added foreign key constraint?

+6
source share
2 answers

It seems like the best way is to right-click on the chart and select "remove table from chart." Then right-click in the white space and select "Add Table". He will then display the newly created relationship.

+4
source

Close the chart. Right-click the name of the chart under the Database Charts node in the tree on the left and select Refresh, and then open the chart again. This worked for me when I tried to get new fields, updated field names, and updated nullable values ​​to display. It also did not break the custom layout I made on the chart, which, I was afraid, might happen. If the chart does not have whole tables, open the chart, right-click the empty space of the chart and select "Add Table" to add the missing tables.

This was the first result when I tried to figure out how to update tables so that they reflect new fields and the like. I was hoping that I would not have to delete / re-add each table one by one!

0
source

Source: https://habr.com/ru/post/1012381/

More articles:


All Articles