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.

closed as off-topic by dezso, Marco, mustaccio, MDCCL, Philᵀᴹ Jun 5 '17 at 16:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – dezso, Marco, mustaccio, MDCCL, Philᵀᴹ
If this question can be reworded to fit the rules in the help center, please edit the question.


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.

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