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

Exporting the Database Structure

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

Scenarios

This section introduces two methods to export the database structure.

  • Method 1

    You can right-click the root node of the DB instance in the navigation tree to export the database structure as required.

  • Method 2

    You can directly right-click the target database node 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 the root node of the DB instance and choose Export Database Structure from the shortcut menu.
  2. On the displayed tab, select the database, tables, and views to be exported.

    • You can click Export to export the database structure and view the export results on your local PC.
    • You can also click Preview to preview the database structure before exporting it.

  • If you select Table and View for Object Type, all objects of a type will be exported, and the number of objects to be exported is not limited.
  • If you select tables or views one by one in the object list, a maximum of 1000 objects can be selected.

Method 2

  1. In the navigation tree on the left, right-click the target database node and choose Export Database Structure from the shortcut menu.
  2. On the displayed tab, select the tables and views to be exported.

    • You can directly click Export to export the database structure. The export file will be downloaded to your local PC.
    • You can also click Preview to preview the export results, such as the number of tables and views, and the export time.

  • If you select Table and View for Object Type, all objects of a type will be exported, and the number of objects to be exported is not limited.
  • If you select tables or views one by one in the object list, a maximum of 1000 objects can be selected.

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