DDL statement-Dataphin(Dataphin)-阿里云帮助中心

Docs ICP Filing Console

MaxCompute DDL statements cover operations on tables, partitions, columns, lifecycles, and views. The following tables list which of these statements Dataphin supports.

Table operations

Operation	Support status
	Yes Note For external tables, Dataphin supports the `msck repair` syntax to populate partition data. For more information, see .
	Yes
	Yes
	You can add a clustering property. You cannot delete a clustering property.
	Yes
	Yes
	Yes
	Yes
	Yes
	Yes
	No
	No
	No

Partition and column operations

Operation	Support status
	You can add a single partition. You cannot add multiple partitions.
	You can drop a single partition. You cannot drop multiple partitions. You cannot drop partitions based on a filter condition.
	Yes
	Yes
	Yes
	Yes
	Yes
	Yes

Lifecycle operations

Operation	Support status
	Yes
	Yes

View operations

Operation	Support status
	Yes
	Yes
	Yes

Previous：OperatorNext：DML operations

该文章对您有帮助吗？