Wednesday, June 4, 2014

How to delete foreign key from a table in mysql?

The following command drops foreign KEY Constraint from table in mysql.

                       
                                                                 
 alter table table_name drop foreign key foreignkey_name;
Eg:
 alter table MerchantOfferImage drop foreign key Merchant_ibfk_1;

0 comments:

Post a Comment