Help Center/ GaussDB(DWS)/ Tool Guide/ Data Studio - Integrated Database Development Tool/ GaussDB(DWS) Tables/ Managing Table Data/ Show DDL
Updated on 2023-04-03 GMT+08:00
View PDF

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.
    • MS Visual C runtime file (msvcrt100.dll) is required to complete 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

Parent topic: Managing Table Data