删除 mysql 所有 外键

SELECT DISTINCT table_name, constraint_name FROM information_schema.key_column_usage WHERE constraint_schema ='databaseName' AND referenced_table_name IS NOT NULL;

 

 

ALTER TABLE *** drop foreign key *** ;