DROP all foreign keys in MYSQL.sql
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;
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;
Comments
Post a Comment