Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is database diagram in SQL Server Management Studio considered as ER diagram?

I just have this simple question. in SQL Server Management Studio there is an option Database Diagrams, is it ER diagram ?

like image 961
Maher Nabil Avatar asked Mar 17 '14 05:03

Maher Nabil


2 Answers

No I believe. ER diagram does not refer to relational data model and can be mapped into different data structures. SQL Server diagram is specific only to relational model and DBMS.

like image 59
msi77 Avatar answered Oct 16 '22 21:10

msi77


Yes, you can do a database diagram.

Expand DataBases --> choose database--> database diagrams --> right click(NEW DB diagram).

like image 2
vhadalgi Avatar answered Oct 16 '22 22:10

vhadalgi