How do you drop a foreign key constraint?

[laredotornado]

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

[Jared]

Do a backup from administrator and wrap your code in the option chunks begin
and end.
<la***********@zipmail.comwrote in message
news:11********************@y41g2000cwy.googlegrou ps.com...

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