MySQL Forums
Forum List  »  Newbie

Re: dropping a foreign key constraint
Posted by: Angelo Chen
Date: July 02, 2009 10:44PM

thanks, it works. however after I did:

alter table order DROP FOREIGN KEY FK38A5EE5F6670A934;

and do a show create table order, constraint is gone, but the key still der:
PRIMARY KEY (`id`),
KEY `FK38A5EE5F6670A934_backup_05_13_09` (`stock_id`),

Options: ReplyQuote


Subject
Written By
Posted
Re: dropping a foreign key constraint
July 02, 2009 10:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.