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 <vikkiatb...@yahoo.in> wrote: > 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? I am using mysql 5.1.32 > > Please, Can any one you help me? > > Thank you > > VIKRAM A > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com