incorrect migration class name. I had problem with this sql query too:
ALTER TABLE `fddp_dim_data_period` DROP FOREIGN KEY `fddp_dim_data_period_ibfk_8`;