Help Center > > User Guide> Microsoft SQL Server Database Management> Table Management> Exporting the Table Structure

Exporting the Table Structure

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

Scenarios

This section introduces two methods to export the 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.

Prerequisites

You have obtained the login permission and logged in to the database management page.

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. In the displayed tab, select the target tables to be exported or previewed.

    • 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 export time.

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 the target table and choose Export Table Structure from the shortcut menu.
  2. On the displayed tab, click Export. You can also click Preview to preview 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