Hi Everyone,
I have a parent table P1(pid,name,ran k) and child tables
C1(Cid,name,sal ,PID), C2(Cid,name,sal ,PID),
C3(Cid,name,sal ,PID). P1 and C1,C2,C3 has foreign key relation.
Now I want to DROP the parent table P1 and Recreate by keeping the data in child tables and also the relation with the newly created table. Can somebody explain how can achieve it?
shema123
Last Activity: Nov 22 '13, 04:54 AM
Joined: Nov 20 '13
Location:
-
shema123 started a topic Hoq to DROP and Re Create the parent table P1 which has child tables C1,C2,C3?in OracleHoq to DROP and Re Create the parent table P1 which has child tables C1,C2,C3?
No activity results to display