Upgrading to 4.0.13 will allow you to drop foreign keys. The innodb manual has
info:
http://innodb.com/ibman.html
Chris
Joe Gaffney wrote:
Can someone help with trying to remove a foreign key constraint from a
table. Each time I run the alter table statement to drop the foreign key I
get the f
t;
> Thanks,
> Joe
>
>
>
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 9:40 PM
> To: Joe Gaffney; MySql
> Subject: Re: droping foreign key
>
>
> HiJoe,
>
> thats not supported yet. You will have t
: Tuesday, June 10, 2003 9:40 PM
To: Joe Gaffney; MySql
Subject: Re: droping foreign key
HiJoe,
thats not supported yet. You will have to recreate the table to remove the
foreign key.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 11日 水曜日 10:13、Joe Gaffney さんは書きました:
> Can someone help with try
HiJoe,
thats not supported yet. You will have to recreate the table to remove the
foreign key.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 11日 水曜日 10:13、Joe Gaffney さんは書きました:
> Can someone help with trying to remove a foreign key constraint from a
> table. Each time I run the alter table
Can someone help with trying to remove a foreign key constraint from a
table. Each time I run the alter table statement to drop the foreign key I
get the following error:
Error Code : 1005
Can't create table
Here is the table structure and the alter table statement I am executing:
ALTER TABLE c
