CANCEL DDL

You can execute the CANCEL DDL statement to cancel a DDL job that is in the RUNNING or PAUSED state. After the DDL job is canceled, the changes that occurred are rolled back, and the data table is restored to the version before the DDL job was executed.

Syntax

CANCEL DDL JOB_ID;

Note You can execute the SHOW DDL statement to obtain the value of the JOB_ID parameter.

Examples

CANCEL DDL 1359628009396502528;
Query OK, 1 row affected (0.03 sec)