Posted by Peter van Schie on 06/30/06 10:51

laredotornado@zipmail.com schreef:
> Hi, I want to drop a foreign key constraint in MySQL 4, but i keep
> getting this error:
>
> mysql> ALTER TABLE ORDER_FORM_CARTRIDGES DROP FOREIGN KEY
> FK2_ORDER_FORM_CARTRIDGES;
> ERROR 1005: Can't create table './REFILLSTATION/#sql-6e1_11.frm'
> (errno: 150)
>
> Grateful for any advice, - Dave
>

Hi Dave,

If you issue the command SHOW INNODB STATUS right after your ALTER TABLE
command, what output do you get? It should give you additional info
concerning the error you just got.

HTH.
Peter.
--
http://www.phpforums.nl

• Next in forum: Re: Date issue
• Prev in forum: Re: Connect to mysql?
• Thread view: Re: how do I drop a foreign key in MySQL 4

[Reply to this message]