Foreign Key constraints dissapear?

admin

Administrator
Staff member
I have noticed that when I change PK of the table A from deferrable to not deferrable in PL/SQL Developer (table tab Keys checkbox Deferrable), FK constraints of different tables referring to table A dissapear.
The same happens when switch PK from not deferrable to deferrable. Is it Oracle or PL/SQL Developer deficiency? It looks pretty serious...

PL/SQL Developer - 7.1.2.1363
Oracle - 10.2.0.3.0
OS - Winsdows XP Professional - SP2
 
If a primary key needs to be dropped and recreated, foreign key references will indeed be dropped as well. This is Oracle Server behavior.
 
;-)
It would be nice feature for PLD to have an option to recreate foreign keys of chield tables when the primmary of parent is recreated.
 
Back
Top