Reversing database

You can reverse engineering an ERD from database. To reverse database:

  1. Select Tools > Database > Reverse Database... from the main menu.

  2. In the Database to Data Model dialog box, keep Reverse Table selected and click Next > button to continue.
    Check Reverse Table
    Check Reverse Table
  3. Fill in the database setting and click Next > button.
    Database setting
    Database setting
  4. Select the tables you want to reverse and click the Next button to start reverse.
    Select tables
    Select tables
  5. After reverse, a new Entity Relationship Diagram is created automatically with a Reversed Entities dialog box.
    Reversed entities
    Reversed entities
  6. Select the tables and drag on the diagram.
    Drag and drop tables to diagram
    Drag and drop tables to diagram
  7. The tables were created on the diagram, click Close button to finish reversing database.
    Reversed ERD
    Reversed ERD
 
Chapter 6. Reversing Database Table of Contents 2. Reversing DDL
 

Product

Try this feature with

Visual Paradigm for UML

Technical Support

Have technical issues or suggestions? Please contact Visual Paradigm Support Team.

Sales Support

Have questions related to registration, licensing or payment? Feel free to contact Visual Paradigm Sales Team.

Discussion Forum

Share your suggestions of opinions at VP Discussion Forum.