Database Diagram Window

See Also   Tasks

The Database Diagram window presents a graphic display of the tables and relationships in your database.

In the Database Diagram window, you can:

When you save a database diagram, the database is updated to match your diagram. The diagram is saved in your project directory and shown in the Database Diagrams folder in Data View. The diagram is also saved in the dtproperties or MicrosoftDTProperties table of your database.

Before you save a diagram, you can view an SQL change script to see the SQL statements that will be applied to the database when you save the diagram. If you close a diagram without saving it, the underlying database remains unchanged.

For more information about database diagrams, see Working in Database Diagrams.