Table has dependent keys and cannot be dropped

Voici le script de création de mes tables:

Code:

---

1 2 3 4 5 6

CREATE TABLE cocktail (id INT NOT NULL AUTO_INCREMENT, name TEXT, recipe TEXT, PRIMARY KEY(id));   CREATE TABLE cocktail_category (id INT NOT NULL AUTO_INCREMENT, name TEXT, PRIMARY KEY(id));   CREATE TABLE belong_to (cocktail_id INT NOT NULL, category_id INT NOT NULL, PRIMARY KEY (cocktail_id, category_id));

---

J'arrive à dropper les 2 dernières tables mais pas la table cocktail

Le message d'erreur est "Table cannot be dropped Reason:Table has dependent keys and cannot be dropped"

Pourquoi ce message?
Merci de m'aider

J'ai trouvé la solution:

Code:

---

1 2 3

SET FOREIGN_KEY_CHECKS=0; DROP DATABASE ... SET FOREIGN_KEY_CHECKS=1;

---