469,622 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

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

Jun 30 '06 #1
1 5525
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

Jul 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jeremiah Jacks | last post: by
1 post views Thread by Sabrina | last post: by
10 posts views Thread by hilz | last post: by
1 post views Thread by Thomas Chille | last post: by
8 posts views Thread by shsandeep | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.