Exporting Table DDL

Follow the steps below to export the table DDL:

  1. In the Object Browser pane, right-click the selected table and select Export DDL.

    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 progress of the operation.

    Note

    • To cancel the export operation, double-click the status to open the Progress View tab and click image1. For details, see Canceling the Table Data Export Operation.

    • If the table name contains characters which are not supported by Windows, the exported file name will not be the same as table name.

    • MS Visual C runtime file (msvcrt100.dll) is required to complete this operation. For details, see Troubleshooting.

    The Export message and the status bar display the status of the completed operation.

    Database Encoding

    File Encoding

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

    Note

    You can select multiple objects and export their DDL. Batch Export lists the objects whose DDL cannot be exported.