Database diagrams allow you to manage your database graphically. You can use database diagrams to create, edit, manage, or delete database objects (tables, table columns, table relationships, constraints, stored procedures, triggers) while you are directly connected to the database in which those objects are stored. In the diagram, you can see the graphical relationship between the objects in your database. You can also define and edit the properties of the database objects, all from within your database diagram.
The tables represented in your diagrams are merely references to tables that reside in the database. An individual database table can exist in more than one database diagram. Thus, a table that appears in many database diagrams actually exists in only one place: the server database itself.
When you modify a table in a database diagram, your modifications are immediately applied to that table in every other diagram in which it appears. Similarly, when you remove a table from a database diagram, it is also removed from the other diagrams in which it appeared. Therefore, if you delete a table in a multiuser environment, the table will be removed from the database diagrams of all other users.
When you save a database diagram, all changes you made to the tables in your diagram and their related objects are saved in the server database. You can choose to select only certain tables in your database diagram and save only those tables without affecting the other tables in the diagram.
In most databases, if you perform any of the following actions on a database table, the table will be automatically re-created in your database when you save the table or the database diagram.
The table must be re-created in the database in order for your database to accept your changes.
When you save a table in which you’ve performed any of these actions, any triggers, bound defaults, and rules associated with each table are also saved.