0

How do I produce the relationship diagram in Microsoft Sql Server? Here is a visual of what I am talking about here: https://i.stack.imgur.com/iRhdN.png

1 Answer 1

3

it is called EER can be foundin SSMS 18

under

Visual database tools Design Database Diagrams.

you find it in the SQL Server Management Studio (SSMS)

https://docs.microsoft.com/en-us/sql/ssms/visual-db-tools/design-database-diagrams-visual-database-tools?view=sql-server-ver15

so you can install a 17 er version of ssms

https://github.com/ktaranov/sqlserver-kit/blob/master/SSMS/README.md#sql-server-management-studio-download-links-and-release-info

And then

  • Go to Sql Server Management Studio >
  • Object Explorer >
  • Databases >
  • Choose and expand your Database. -Under your database right click on "Database Diagrams" and select "New Database Diagram".
  • 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).
  • Click add. -Wait for it to complete. Done!

or use some other tool like

https://dbeaver.io/download/

here is a the manual for eer

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.