Updated on 2023-03-17 GMT+08:00

Exporting Table DDL and Data

The exported table DDL and data include the following:

  • DDL of the table
  • Columns and rows of the table

Perform the following steps to export the table DDL and data:

  1. 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.

  2. Click OK.

    The Save As dialog box is displayed.

  3. In the Save As dialog box, select the location to save the DDL and click Save. The status bar displays the operation progress.

    • To cancel the export operation, double-click the status bar to open the Progress View tab and click . For details, see Canceling Table Data Export.
    • If the file name contains characters that are not supported by Windows, the file name will be different from the schema name.
    • The MS Visual C Runtime file (msvcrt100.dll) is required for this operation. For details, see Troubleshooting.

    The Data Exported Successfully dialog box and status bar display the status of the completed operation.

    Database Encoding

    File Encoding

    Support for 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

    You can select multiple objects from ordinary and partitioned tables to export DDL and data, including columns, rows, indexes, constraints, and partitions. Batch Export lists the objects whose DDL and data cannot be exported.