Help Center> Data Admin Service> User Guide> MySQL> Database Management> Viewing Data Dictionary of a Database
Updated on 2023-12-13 GMT+08:00

Viewing Data Dictionary of a Database

A data dictionary is a collection of information that describes data, including the database name, database character set, table name, table size, number of records in a table, table character set, table field, table index, table description, field type, field precision, and field description.

You can view data dictionary of a database on the DAS console or download the PDF file to your local PC.

Prerequisites

There are available tables in the current database.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. In the database list, locate the database whose data dictionary you want to view and click Data Dictionary in the Operation column.

    Figure 1 Homepage

  7. On the displayed page, view the content in Tables and List of Table Schema of the current database.

    Figure 2 Data dictionary file

  8. Click Export In PDF to download it to your local PC if needed.