Steve Hay writes:
> Sinisa Milivojevic wrote:
> I understand that if I was issuing DROP TABLE statements then I would
> need to put them in the right order, but I'm doing a DROP DATABASE.
> Surely foreign key constraints should not be checked when the entire
> database is being dropped.
> If they /are/ supposed to be checked then the other cases that I
> mentioned above (where DROP DATABASE worked fine) are not working properly!
> - Steve
Just as our manual says, drop tables one by one, as foreign
constraints need be constrained to a single database.
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus
Meet the MySQL at User Conference ! (April 14-16, 2004)