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

Show DDL

To display a DDL query for a table, perform the following steps:

  1. Right-click the table, and then select Show DDL.

    Data Studio displays the DDL of the selected table.

    • A new terminal window is opened each time you select to show DDL.
    • The MS Visual C Runtime file (msvcrt100.dll) is required for this operation. For details, see Troubleshooting.

    Database Encoding

    File Encoding

    Show 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