how do I drop a foreign key in MySQL 4

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

Re: how do I drop a foreign key in MySQL 4

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