3

In SQL Server Object Explorer, I see a list of tables under "Tables" under my database within the "Databases" directory. How do I automatically create a UML diagram of these tables. How do I do this?

jerryh91
  • 1,777
  • 10
  • 46
  • 77
  • Do you want to automatically generate them or create them by hand? – Gangnus Feb 03 '15 at 16:03
  • Automatically generated – jerryh91 Feb 03 '15 at 16:15
  • Then correct the second sentence of the question, please. – Gangnus Feb 03 '15 at 16:20
  • While this is not a direct answer, you may want to look into this article from Phil Factor about generating PlantUML diagrams using SQL statements: https://www.red-gate.com/simple-talk/sql/sql-tools/automatically-creating-uml-database-diagrams-for-sql-server/ – Marcel Oct 16 '18 at 06:09

1 Answers1

-1

  1. UML has no diagram for database content.

  2. Classes from class diagram can be implemented as DB tables. They CAN model simple tables. But if you have a table with inner references, it could be modelled as one or several classes. And nobody except you can say exactly how many classes will be got from a table.

  3. MS Visio has non-UML Database diagram. THEY have Table element and surely, can be generated from most of the DBs. Look here

Gangnus
  • 24,044
  • 16
  • 90
  • 149