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

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

<laredotornado@zipmail.comwrote in message
news:1151683633.800473.8610@y41g2000cwy.googlegrou ps.com...

Quote:

Hi, I want to drop a foreign key constraint on an INNODB table in MySQL
4, but i keep getting this error:
>
mysqlALTER 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
>

How do you drop a foreign key constraint?

re: How do you drop a foreign key constraint?

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about