SELECTCONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' DROP FOREIGN KEY ',CONSTRAINT_NAME,' ;')FROM information_schema.TABLE_CONSTRAINTS c
WHERE c.TABLE_SCHEMA='库名'AND c.CONSTRAINT_TYPE='FOREIGN KEY';
MySql 删除数据库中所有外键SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' DROP FOREIGN KEY ',CONSTRAINT_NAME,' ;') FROM information_schema.TABLE_CONSTRAINTS c WHERE c.TABLE_SCHEMA='库名' AND c.CONSTRAINT_TYPE='FOREIGN KEY';