How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?

by
  1. Go to SQL Server Management Studio →
  2. Object Explorer →
  3. Databases →
  4. Choose and expand your database.
  5. Under your database, right click on “Database Diagrams” and select “New Database Diagram”.
  6. It will a open a new window. Choose tables to include in the ER diagram (to select multiple tables, press Ctrl or Shift key and select tables).
  7. Click Add.
  8. Wait for it to complete. Done!

You can save the generated diagram for future use.

Screenshot

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)