SELECT
concat(' ALTER TABLE ',TABLE_CONSTRAINTS.CONSTRAINT_SCHEMA,'.',TABLE_CONSTRAINTS.TABLE_NAME,' DROP FOREIGN KEY ',TABLE_CONSTRAINTS.CONSTRAINT_NAME,';')
FROM
TABLE_CONSTRAINTS where CONSTRAINT_TYPE = 'FOREIGN KEY'
AND CONSTRAINT_SCHEMA in ('blossom','blossom_bak')