DROP all foreign keys in MYSQL database

Question

Foreign keys are causing me too many problems modifying an database structure to meet new requirements - I want to modify primary keys but it seems I can't when foreign keys reference the table in question (I think because MySQL drops the table and re-creates).

So while I work on the DB, I'd like to simply remove all the foreign keys and re-create them later. Is there a neat way to do so?

Answer 1

Run

SELECT concat('ALTER TABLE ', TABLE_NAME, ' DROP FOREIGN KEY ', CONSTRAINT_NAME, ';')  FROM information_schema.key_column_usage  WHERE CONSTRAINT_SCHEMA = 'db_name'  AND referenced_table_name IS NOT NULL; 

and run the output.