Help Center/ Data Warehouse Service / More Documents/ Tool Guide (Kuala Lumpur Region)/ DSC/ Migrating MySQL Syntax/ Table (Optional Parameters and Operations)/ TRUNCATE (Table Deletion)
Updated on 2025-10-14 GMT+08:00
View PDF
Share

TRUNCATE (Table Deletion)

In MySQL, the TABLE keyword can be omitted when the TRUNCATE statement is used to delete table data. DWS does not support this feature. In addition, DSC will add CONTINUE IDENTITY RESTRICT to the TRUNCATE statement for migration.

Input

1
2
 
TRUNCATE TABLE `public`.`test_create_table01`;
TRUNCATE TEST_CREATE_TABLE01;

Output

1
2
 
TRUNCATE TABLE "public"."test_create_table01" CONTINUE IDENTITY RESTRICT;
TRUNCATE TABLE "public"."test_create_table01" CONTINUE IDENTITY RESTRICT;