By saving a database diagram, you can save all the changes you made to it, including any changes you made to the tables, columns and other database objects.
If you made changes to tables in an existing database diagram, the Save dialog box appears and displays a list of changes that will be saved in the database when you save your database diagram.