Reverse engineer MS SQL database to ERD

sql-server database reverse-engineering erd
Ceesz picture Ceesz · Feb 24, 2015 · Viewed 15.2k times · Source

How can I create an ERD from an existing database in Microsoft SQL Server 2014?

The ERD needs to resemble: enter image description here

Answer

Kritner picture Kritner · Feb 24, 2015

The easiest way to do so, would be from SQL Server Management Studio (SSMS).

Go to Database -> Database Diagrams -> Right click -> Add new diagram -> Add the desired tables for your ERD. Given your tables actually have relationships defined between them the relationships will be drawn as well.

It should be noted, this will be a very basic looking ERD, and might not be quite to the standard of what you would expect out of an ERD.

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More