Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Tables (GaussDB A)> Managing Table Data> Exporting Table DDL and Data
Exporting Table DDL and Data
Exporting the table DDL and data exports the following:
- DDL of the table.
- Columns and rows of the table.
Follow the steps below to export the table DDL:
- In the Object Browser pane, right-click the selected table and select Export DDL and Data.
The Data Studio Security Disclaimer dialog box is displayed.
- Click OK.
The Save As dialog box is displayed.
- In the Save As dialog box, select the location to save the DDL and click Save. The status bar displays the progress of the operation.
- To cancel the export operation, double-click the status to open the Progress View tab and click
. - If the table name contains characters which are not supported by Windows, the exported file name will not be the same as table name.
- Microsoft Visual C runtime file (msvcrt100.dll) is required to complete this operation. Refer to Troubleshooting for more information.
The Export message and status bar display the status of the completed operation.
Database Encoding
File Encoding
Supports Exporting DDL
UTF-8
UTF-8
Yes
GBK
Yes
LATIN1
Yes
GBK
GBK
Yes
UTF-8
Yes
LATIN1
No
LATIN1
LATIN1
Yes
GBK
No
UTF-8
Yes
Multiple objects can be selected to export DDL and data on regular and partitioned tables. It exports columns, rows, indexes, constraints, and partitions. Refer to Batch Export for list of objects not supported for export DDL and Data operation.
- To cancel the export operation, double-click the status to open the Progress View tab and click
Parent topic: Managing Table Data
Last Article: Exporting Table DDL
Next Article: Exporting Table Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.