enable and disable foreign key constraint.
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
Subject
Views
Written By
Posted
enable and disable foreign key constraint.
30865
December 02, 2008 06:20AM
15591
January 08, 2009 06:13AM
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.