title: Generating DDL and documentation from ER-diagram
body: <p>Looking for a way to have 3 artefacts in sync:</p>
  
  <ul>
  <li>SQL DDL for creating schema tables </li>
  <li>Diagram presenting tables, columns and relationships </li>
  <li>HTML documentation describing tables and columns,
  at least column name, data type and comment/remark</li>
  </ul>
  
  <p>Ideally, there should be one master format from which the others can be generated.
  Generating diagrams from other formats usually leads to ugly, not-too-friendly results.</p>
  
  <p>So, is there any tool supporting</p>
  
  <ul>
  <li>drawing a schema diagram, allowing me to define comments/remarks on columns</li>
  <li>exporting SQL DDL for creating tables in DB</li>
  <li>generating HTML documentation. This is optional, if column remarks can be included in DDL (e.g. "<code>column1 integer, -- my remarks</code>"). Converting DDL to HTML is trivial.</li>
  </ul>
  
  <p>My environment is DB2 9.7 LUW.</p>