25/02/2010, at 11:33 PM, Jim Lyons wrote:
Yes - you can drop a foreign key constraint, use the 'alter
table ... drop
foreign key ...' command. If you get an error message, post the error
message.
On Thu, Feb 25, 2010 at 6:03 AM, Vikram A
wrote:
Hi,
I tried to remove foreign
Yes - you can drop a foreign key constraint, use the 'alter table ... drop
foreign key ...' command. If you get an error message, post the error
message.
On Thu, Feb 25, 2010 at 6:03 AM, Vikram A wrote:
> Hi,
>
> I tried to remove foreign key constraint in innodb tabl
Hi,
I tried to remove foreign key constraint in innodb table.
I tried with different ways; but i am unable to drop the constraints.
http://lists.mysql.com/mysql/113053
It says that, droping the foreign key constraint it is not possible in innodb
engine.
Is it so? or any other possibilities
Pierre,
Tuesday, June 25, 2002, 3:54:28 PM, you wrote:
PB> how to remove a foreign key constraint without recreating the innodb table ?
No, it's not possible ...
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ens
how to remove a foreign key constraint without recreating the innodb table ?
thanks,
Pierre
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
