I have 3 tables. P_1 = primary key
P_2 references P_1, and P_3 references the P-2 column referencing P_1.
I dropped the PK constraint on P_1 with cascade option. However P_3 still reference P_1.
I believed this to be the case when I started.
May sound like a dumb question seeing as how I already tried it, but when i drop a Pk constraint, will a 3rd table referencing a second tables column which references the original column which has the PK constraint, will that 3rd column still maintain its FK reference to the second table..?
I remember reading somewhere about this being true, at least I'm sure i read it in one of the oradocs, I just want to ask.
Thanks.