Microsoft Sql Entity Relationship Diagram. How do i view relationship diagrams in sql server management studio. There are three basic elements in er diagrams.
Its an aspect of your business that needs to be stored such as a book or author. Conceptdraw diagram software gives the ability to describe a database using the entity relationship model. Database diagrams will only help you if the tables have fks setup between the tables.
Up to 10 attachments including images can be used with a maximum of 30 mib each and 300 mib total.
Go to sql server management studio object explorer databases choose and expand your database. For a good database design it is essential to have an entity relationship diagram. Diagrams are updated for each cu. Up to 10 attachments including images can be used with a maximum of 30 mib each and 300 mib total.