Part I. Getting started

Part II. UML modeling

Part III. Project glossary

Part IV. BPMN toolset

Part V. Project management

Part VI. Modeling toolset

Part VII. ArchiMate tools

Part VIII. Team collaboration

Part IX. Code engineering

Part X. Database design and engineering

Part XI. Advanced modeling toolset

Part XII. Document production

Part XIII. Business modeling

Part XIV. Business rule

Part XV. Agile development

Part XVI. Wireframe

Part XVII. Impact analysis

Part XVIII. CMMN toolset

Part XIX. SoaML modeling

Part XX. Design animation

Part XXI. IDE Integration

Part XXII. Interoperability and integration

Part XXIII. Process simulation

Part XXIV. Zachman and BMM

Part XXV. Appendix A - Application Options

Part XXVI. Appendix B - Project Options

Part XXVII. Appendix C

 

Reverse Engineering ERD from DDL

Visual Paradigm supports reverse engineering ERD from .ddl and .sql. It forms nice Entity Relationship Diagram out of the create and alter statements written in DDL (Data Definition Language). With an ERD, you can produce a data dictionary, or to revise the design and generate a database, etc.

To reverse engineering ERD from DDL:

  1. Select Tools > DB > Reverse DDL... from the toolbar. This opens the Reverse DDL window.
    The Reverse DDL window
    The Reverse DDL window
  2. In the Reverse DDL window, enter the file path of the .sql or .ddl file to reverse.
  3. Select the kind of database that supports your DDL file.
  4. Select the encoding of the .sql or .ddl file. Leave it <Default> if you are uncertain.
  5. If you want to form an Entity Relationship Diagram automatically after reversal, keep Generate ERD reversed. If you uncheck it, entity elements will be formed without creating any diagrams. No matter what, you can visualize entities later on if you want to.

Related Resources

The following resources may help you to learn more about the topic discussed in this page.

 
1. Reverse Engineering ERD from Database Table of Contents 3. Generating Database from ERD

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.OK