How to generate Entity Relationship (ER) Diagram of a database using Microsoft SQL Server Management Studio?

sql-server entity-relationship
Temp O'rary picture Temp O'rary · Sep 3, 2015 · Viewed 190.8k times · Source

I want to generate ER diagram of SQL database using Microsoft SQL Server Management Studio however, I dont know how to.

I found this technique online http://forums.asp.net/t/1790223.aspx?Making+ER+Diagram+from+SQL+Server+2008+Database

However, I am not able to see "Database Node" or "Database Diagrams" nodes as mentioned in the 1st and 2nd steps.

Hence, please let me know how can I generate ER diagram from an existing DB.

UPDATE:

From the comments below, I realize that I was right in my understanding that Database node means the node with my database name. But then my problem is I am not able to find the "Database Diagrams" node under my Database name. What should I do now so that I can see it.

PS: Its not a local database.

Answer

DhaRmvEEr siNgh picture DhaRmvEEr siNgh · Jun 24, 2016
  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 ER-Diagram (to select multiple tables press "ctrl" or "shift" button and select tables).
  7. Click add.
  8. Wait for it to complete. Done!!

You can save generated diagram for future use.

screenshot

Related questions

Turn off constraints temporarily (MS SQL)

I'm looking for a way to temporarily turn off all DB's constraints (eg table relationships). I need to copy (using INSERTs) one DB's tables to another DB. I know I can achieve that by executing commands in proper order (to …

Read More
Implementing one-to-zero-or-one relation in SQL Server

I'm using Entity Framework 4.1 database first approach. I've used legacy database. In my edmx file which created entity classes based on tables in the legacy database, there is a one-to-zero-or-one association between some entities. Although I explored the tables of …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More