All Products
Search
Document Center

ER diagram

Last Updated: Sep 24, 2019

This section describes operations of the ER diagram in DMS.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Background

This example uses the MySQL database.

Procedure

  1. Log on to the DMS console. The homepage is displayed, as shown below:

    }Homepage

  2. Select a MySQL database, and click Log On to Database.

  3. On the top menu bar, choose Tools > ER Diagram to enter the next page.

    Choose Tools > ER Diagram

  4. The ER diagram shows the relationship between the tables of the current database and provides the table names, column names, indexes, and relationships.

    1

  5. You can use the following features.

    E-R

    • Click the DB:mysql in drop-down list to switch to another database.

    • Click the Order: Sort in drop-down list to sort tables in descending order of relationship count or field count or in ascending order of table name or field count.

    • Click Refresh to refresh the current ER diagram.

    • Click View SQL Scripts to list the SQL statements used to create all the tables of the current database.

    • Click Download SQL Scripts to download the SQL statements used to create all the tables of the current database.

    • Click Download XML Files to convert the table creation SQL statements of the current database to XML files, as shown below:

  6. Double-click the name of a table column to view the column definition. Double-click a table name to edit the table on a new page, as shown below:

    4