How do you drop a foreign key constraint?

Hi, I want to drop a foreign key constraint on an INNODB table 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 you drop a foreign key constraint?

Do a backup from administrator and wrap your code in the option chunks begin
and end.


wrote in message
news:1151683633.800473.8610@y41g2000cwy.googlegroups.com...
> Hi, I want to drop a foreign key constraint on an INNODB table 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
>