Help Center > > User Guide> MySQL Database Management> Table Management> Exporting Table Structure

Exporting Table Structure

Updated at: Mar 20, 2020 GMT+08:00

Prerequisites

You have logged in to the DAS console.

Scenarios

This section introduces two methods to export table structure.

  • Method 1

    You can right-click Tables in the navigation tree to export the table structure.

  • Method 2

    You can directly right-click the target table in the navigation tree to export its structure.

Method 1

  1. In the navigation tree on the left, right-click Tables under the target database and choose Export Table Structure from the shortcut menu.
  2. On the displayed page, click Export. You can also click Preview to preview table structure before exporting the structure. The export file will be downloaded to your local PC.

You can select the target tables in either of the following ways:

  • If you select Table for Object Type, you do not have to select table names one by one in the object list. The number of tables is not limited.
  • If you select tables from the object list, a maximum of 1000 tables can be selected at a time.

Method 2

  1. In the navigation tree on the left, right-click Tables under the target database and choose Export Table Structure from the shortcut menu.
  2. On the displayed page, click Export. You can also click Preview to preview table structure before exporting the structure.

    • You can directly click Export to export the table structure. The export file will be downloaded to your local PC.
    • You can also click Preview to preview the results and the time taken to export the table structure. Then click Export to export the table structure. The export file will be downloaded to your local PC.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel