how to drop partition without dropping data in MySQL? December 29, 2023 by Tarik ALTER TABLE tbl REMOVE PARTITIONING; Source: ALTER TABLE Statement in MySQL Reference Manual