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. Link to comment https://forums.phpfreaks.com/topic/14927-drop-foreign-key-in-mysql-519/ Share on other sites More sharing options...
fenway Posted July 18, 2006 Share Posted July 18, 2006 Is this key the primary key? Link to comment https://forums.phpfreaks.com/topic/14927-drop-foreign-key-in-mysql-519/#findComment-59876 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. Link to comment https://forums.phpfreaks.com/topic/14927-drop-foreign-key-in-mysql-519/#findComment-60527 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.