MySQL Forums
Forum List  »  InnoDB

enable and disable foreign key constraint.
Posted by: ushant shokeen
Date: December 02, 2008 06:20AM

Hi,

In my project I have to disable foreign key constraint and enable also.
I tried with SET foreign_key_constraints=0, but this statement works only if we apply it manually.
But I need to use this statement or its alternative in some query. like in oracle we use "alter table table_name disable constraint constraint_name from dba_constraints where constraint_type='R';"

Any help regarding this will be highly appreciated.

Thanks and Regards,
Ushant

Options: ReplyQuote


Subject
Views
Written By
Posted
enable and disable foreign key constraint.
30865
December 02, 2008 06:20AM


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.