All Products
Search

This Product

    Dataphin:DDL statement

    Document Center

    Dataphin:DDL statement

    Last Updated:Mar 31, 2026

    Data Definition Language (DDL) statements in MaxCompute cover operations on tables, partitions, columns, lifecycles, and views. This topic describes the MaxCompute DDL statements that are supported by Dataphin.

    Table operations

    Operation

    Support status

    Create table

    Yes

    Note

    For external tables, Dataphin supports the msck repair syntax to populate partition data. For more information, see Access OSS by using the built-in extractor.

    Modify table comment

    Yes

    Modify table last modified time

    Yes

    Modify table clustering properties

    • You can add a clustering property.

    • You cannot delete a clustering property.

    Rename table

    Yes

    Drop table

    Yes

    View table or view information

    Yes

    View partition information

    Yes

    List tables and views in a project

    Yes

    List all partitions

    Yes

    Change table owner

    No

    Truncate a non-partitioned table

    No

    View CREATE TABLE statement

    No

    Partition and column operations

    Operation

    Support status

    Add partition

    • You can add a single partition.

    • You cannot add multiple partitions.

    Drop partition

    • You can drop a single partition.

    • You cannot drop multiple partitions.

    • You cannot drop partitions based on a filter condition.

    Add column or comment

    Yes

    Rename column

    Yes

    Modify column comment

    Yes

    Modify partition last modified time

    Yes

    Rename partition

    Yes

    Merge partitions

    Yes

    Lifecycle operations

    Operation

    Support status

    Modify table lifecycle

    Yes

    Disable or enable lifecycle

    Yes

    View operations

    Operation

    Support status

    Create or update view

    Yes

    Rename view

    Yes

    Drop view

    Yes