2

I am interested in creating a map of my database, so that I may understand it better. I am having difficulties understanding which tables relate to other tables, and I think a map, or flowchart would help me greatly. Has anyone done this? If so, how did you accomplish it?

Anthony Sims
  • 171
  • 4
  • 15

3 Answers3

2

If you have Microsoft visio, that's a good software in creating a flowchart.

Aldrin
  • 756
  • 6
  • 18
2

You can try SQL Server Management Studio Express. Just right click on Database Diagrams and create a new diagram. You can select existing tables that you desire.

You can follow an excellent guide step by step here.

Gustavo Morales
  • 2,614
  • 9
  • 29
  • 37
  • This is awesome. Thank you very much. Just what I needed. – Anthony Sims May 26 '16 at 14:52
  • While I can see how this would be useful, I might have a different problem. My database is massive. There are literally hundreds of tables. – Anthony Sims May 26 '16 at 15:23
  • 1
    There isn't a simple answer to this problem. Take a look at this answer, [How to generate a diagram of a very large database schema (SQL Server)](http://stackoverflow.com/questions/3503223/how-to-generate-a-diagram-of-a-very-large-database-schema-sql-server), might help you – Gustavo Morales May 26 '16 at 15:33
1

I use Lucid Chart (www.lucidchart.com) occasionally because we don't have Visio either. They offer a free account, which works pretty well, apart from the limit on the number of items you can put in one document (I want to say it's a limit of 60 entities).

TWD
  • 50
  • 7