Jump to content


Photo

Drop Foreign Key In Mysql 5.1.9


  • Please log in to reply
2 replies to this topic

#1 ashokkumar

ashokkumar
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 18 July 2006 - 09:32 AM

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 in
MySQL 5.1.9 version.?

Reply immediately..

Regards,
S.Ashokkumar
Buddies Infotech Pvt Ltd
India.


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 July 2006 - 01:01 PM

Is this key the primary key?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 19 July 2006 - 03:52 PM

If it's not, I'm not really sure... you must be getting some sort of message / output.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users