SELECT DISTINCT table_name, constraint_name FROM information_schema.key_column_usage WHERE constraint_schema ='databaseName' AND referenced_table_name IS NOT NULL;
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 ...