Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.
Asked
Active
Viewed 1,271 times
6
NO WAR WITH RUSSIA
- 54,954
- 34
- 200
- 411
Abhijit Gujar
- 279
- 1
- 2
- 12
-
1http://www.dbschema.com/ – a_horse_with_no_name Jun 02 '17 at 07:29
1 Answers
5
You need a Entity Relation Diagram (ERD) generator. The most popular and advanced one that I know of that is FOSS is SchemaCrawler.
It does everything you want anyway. Though the diagrams are generated with Graphviz (so don't expect Visio quality).
You may want to go scavenger hunting through different graphviz viewers. This one using d3 seems to be pretty decent.
NO WAR WITH RUSSIA
- 54,954
- 34
- 200
- 411