ashokkumar Posted July 18, 2006 Share Posted July 18, 2006 hi..i am new to mysql 5. I created one table with foreign key field. Then i tried to drop the foreign key from the table by using the Query: " alter table <table name> drop foreign key <foreign key name>;" . But, foreign key is not dropped from the table,but query executed sucessfuly.What is way to drop the foreign key from the table.If any one know the solution... Please tell me.... it is very urgent and important one...What is query to drop the foreign key from the table inMySQL 5.1.9 version.?Reply immediately..Regards,S.AshokkumarBu[color=blue][/color]ddies Infotech Pvt LtdIndia. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 18, 2006 Share Posted July 18, 2006 Is this key the primary key? Quote Link to comment Share on other sites More sharing options...
fenway Posted July 19, 2006 Share Posted July 19, 2006 If it's not, I'm not really sure... you must be getting some sort of message / output. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.