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

Exporting the View Structure

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

Scenarios

This section introduces two methods to export the view structure.

  • Method 1

    You can right-click the Views node in the navigation tree to export the view.

  • Method 2

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

Prerequisites

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

Procedure

  1. In the navigation tree on the left, right-click Views under the target database and choose Export View Structure from the shortcut menu.
  2. On the displayed tab, select the target views and click Export. You can also click Preview to preview the view structure. The export file will be downloaded to your local PC.

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

  • If you select View for Object Type, you do not have to select view names one by one in the object list. The number of views is not limited.
  • If you select views from the object list, a maximum of 1000 views can be exported.

Method 2

  1. In the navigation tree on the left, right-click the target view and choose Export View Structure from the shortcut menu.
  2. On the displayed tab, click Export. You can also click Preview to preview the view 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